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&...]