That also worked for me. Almost Now what I recieved is something very odd:
13:39:59,755 INFO [STDOUT] DatabaseServerLoginModule, dsJndiName=java:/PimpfOracleDS 13:39:59,756 INFO [STDOUT] principalsQuery=select passphrase from users where username = ? 13:39:59,756 INFO [STDOUT] rolesQuery=SELECT ROLENAME, 'ROLES' FROM ROLES WHERE ROLEID = (SELECT ROLEID FROM USERS WHERE USERNAME = ?) 13:39:59,922 INFO [STDOUT] Going to get roles for user pimpf 13:39:59,927 INFO [STDOUT] Assign user to role user 13:39:59,965 ERROR [RoleBasedAuthorizationInterceptor] Insufficient permissions, principal=pimpf, requiredRoles=[user], principalRoles=null Obviously it takes user passphrase and rolename correctly. It tries to assign user to rolename 'user' and then it says: principalRoles = null? Here is the result of the rolesQuery: SELECT ROLENAME, 'ROLES' FROM ROLES WHERE ROLEID = (SELECT ROLEID FROM USERS WHERE USERNAME = 'pimpf') ROLENAME ROLES ----------- -------- user ROLES Any ideas?! Please help View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3934695#3934695 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3934695 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
