This kind of a newbie question. I have two entities Employee and User both have 'username' field. The username is unique in the namespace of two combined.
Currently I have the following in my login-config.xml (using DatabaseServerLoginModule)
<module-option name= "principalsQuery">select password from users where username=?</module-option> <module-option name= "rolesQuery">select 'User', 'Roles' from users where username=?</module-option>
Show the ddl for the tables in question as I don't know what the username, password and role columns are from this description.