Hi
I have following contents in my login-config.xml. Can anyone tell me when these quesries actulally run ?
<?xml version='1.0'?>
<!DOCTYPE policy PUBLIC
"-//JBoss//DTD JBOSS Security Config 3.0//EN"
"http://www.jboss.org/j2ee/dtd/security_config.dtd">
<application-policy name="r911-SecureRealm">
<login-module code="com.r911.security.R911LoginModule" flag="required">
<module-option name="dsJndiName">java:/R911DB</module-option>
<module-option name="principalsQuery">SELECT R911User.Password, R911User.userId 'PrincipalID' FROM R911User WHERE UserName=?</module-option>
<module-option name="rolesQuery">
SELECT UserGroup.UserGroupName, 'Roles'
FROM R911User
LEFT JOIN UserMapping ON R911User.UserId = UserMapping.UserId
LEFT JOIN UserGroup ON UserMapping.UserGroupId = UserGroup.UserGroupId
WHERE R911User.Username =?
</module-option>
</login-module>
</application-policy>
Thanks
Imad