1 Reply Latest reply on Apr 9, 2004 10:32 AM by Scott Stark

    principalsQuery and rolesQuery

    Erez Efrati Newbie

      Hi,

      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>
      


      How do I change the select so it would look also in the Employee table? (Kind of an SQL question but still relates strongly to JAAS).

      Thanks in advance,
      Erez