[jboss-dev-forums] [JBoss Web Development] - Re: Authorization issue while implementing login module with DatabaseServerLoginModule

[noeternity]

noeternity [http://community.jboss.org/people/noeternity] created the discussion

"Re: Authorization issue while implementing login module with DatabaseServerLoginModule"

To view the discussion, visit: http://community.jboss.org/message/596789#596789

--------------------------------------------------------------
The error is here:
<module-option name="rolesQuery">SELECT Role, RoleGroup FROM Roles WHERE PrincipalID=?</module-option>

As long as your RoleGroup does not resolve to "Roles" it will not work with the default JEE mechanisms. So either make sure every entry for RoleGroup in your DB is "Roles" or change the query to:

SELECT Role, 'Roles' FROM Roles WHERE PrincipalID=?

You can then delete the column RoleGroup from the DB.

Frank
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/596789#596789]

Start a new discussion in JBoss Web Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2112]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-dev-forums/attachments/20110331/6ebaf067/attachment.html