Tokajac wrote: > Hello! > > For Connection on database i initialize in context.xml: > [CODE] > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="0" > driverName="com.Driver" > connectionURL="jdbc:url" > connectionName="CONNAME" connectionPassword="CONPASS" userTable="BFWBBUSR" > userNameCol="LOGINNM" userCredCol="USRPASS" > userRoleTable="BFWBBUSR" > roleNameCol="ROLEID"/> > [/CODE] > j_security_check works fine. > > Now, i want to check another column on login: userstatus. Value of the > column can be 0 or 1. Only users with correct username and status 1 can > login. > > How can i do this with j_security_check?
Use a view rather than a table for userTable that is based on something along the lines of: SELECT * FROM BFWBBUSR WHERE userstatus=1; Mark --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
