[jboss-user] [Security & JAAS/JBoss] - Re: Error 403 when using DatabaseServerLoginModule

[jaikiran]

In your login-config.xml:

  | <module-option
  | 					name="usersProperties">
  | 					SELECT password for principals WHERE principalId=?
  | 				</module-option>
  | 				<module-option
  | 					name="rolesProperties">
  | 				SELECT role as Roles, roleGroup as RoleGroups from roles where principalId=?
  | 				</module-option>

Note the properties marked in bold. They are incorrect. You should be having:

<module-option name = "principalsQuery">your query</module-option>
  | 
  |              <module-option name = "rolesQuery"> your query </module-option>



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983181#3983181

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983181