4 Replies Latest reply on Sep 6, 2005 7:10 PM by Mike Slyter

    JAAS Issues rolesQuery with a hashed username from DatabaseL

    Mike Slyter Newbie

      The authentication workes fine.
      Here is the query that is fired to get the roles:

      select Web_App_Role,'Roles' from WEB_APP_USER_ROLES where Web_App_User_Principal=@p0ý


      Here are the security setting:
      <application-policy name = "labor-commission-safety">
       <authentication>
       <login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule" flag = "required">
       <module-option name = "unauthenticatedIdentity">guest</module-option>
       <module-option name="dsJndiName">java:/jdbc/SybaseASEDevDB</module-option>
       <module-option name="principalsQuery">select Password from SA_INSPECTOR where State_Number=?</module-option>
       <module-option name="rolesQuery">select Web_App_Role,'Roles' from WEB_APP_USER_ROLES where Web_App_User_Principal=?</module-option>
       </login-module>
       </authentication>
       </application-policy>


      How do I stop this? The user name is not hashed.

      Any Help would be appreciated.