CREATE TABLE  "USERS"
   ("USERNAME" NVARCHAR2(50) NOT NULL ENABLE,
    "PASSWORD" NVARCHAR2(50) NOT NULL ENABLE,
     CONSTRAINT "USERS_PK" PRIMARY KEY ("USERNAME") ENABLE
   ) ;

CREATE TABLE  "USERSROLE"
   (    "ROLENAME" NVARCHAR2(50) NOT NULL ENABLE,
    "USERNAME" NVARCHAR2(50),
     CONSTRAINT "USERSROLE_PK" PRIMARY KEY ("ROLENAME") ENABLE
   ) ;ALTER TABLE  "USERSROLE" ADD CONSTRAINT "USERSROLE_FK" FOREIGN KEY ("USERNAME")
      REFERENCES  "USERS" ("USERNAME") ENABLE;

<?xml version="1.0" encoding="UTF-8"?>
<Context   path="/ProjectName">                                                                                                                                       ">
    <Realm  className="org.apache.catalina.realm.JDBCRealm"
            driverName="oracle.jdbc.driver.OracleDriver"
            connectionURL="jdbc:oracle:thin:@localhost:1521:xe"
            connectionName="DBName" connectionPassword="myPassword"
            userTable="users" userNameCol="USERNAME" userCredCol="PASSWORD"
            userRoleTable="USERSROLE" roleNameCol="ROLENAME" />
</Context>

<security-constraint>
        <web-resource-collection>
            <web-resource-name>wholesale</web-resource-name>
            <url-pattern>/*</url-pattern>
            <http-method>GET</http-method>
            <http-method>POST</http-method>
        </web-resource-collection>

        <auth-constraint>
            <role-name>Admin</role-name>
        </auth-constraint>
</security-constraint>


    <login-config>
        <auth-method>FORM</auth-method>

        <form-login-config>
            <form-login-page>/login.html</form-login-page>
            <form-error-page>/login-error.html</form-error-page>
        </form-login-config>

    </login-config>
    <security-role>
        <role-name>Admin</role-name>
    </security-role>