Hi I am using a DatabaseServerLoginModule, configured as follows: | <login-module code= "org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="optional"> | | <module-option name="principalsQuery">select login,passwd from contractors where login=?</module-option> | <module-option name="rolesQuery">select login,role,'Roles' from roles where login=?</module-option> | <module-option name="dsJndiName">java:/MYDS</module-option> | </login-module> | As stated in http://www.jboss.org/index.html?module=bb&op=viewtopic&t=20402 I have used the same expected strutures for the table. (I have also tried using only two fields for rolesQuery and only one field for principalsQuery). Authentication works like a charm, but JBoss is not retrieving the users. The log output, on TRACE mode says
| 2004-02-24 20:17:48,280 TRACE [org.jboss.web.catalina.security.JBossSecurityMgrRealm] User: moralito is NOT authorized, requiredRoles=[project_2_create], userRoles=null | However, if I run the principals Query it returns results. The user does belong to this role View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3822795#3822795 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3822795 ------------------------------------------------------- SF.Net is sponsored by: Speed Start Your Linux Apps Now. Build and deploy apps & Web services for Linux with a free DVD software kit from IBM. Click Now! http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
