[jboss-user] [Security & JAAS/JBoss] - How to read users/roles from a database?

Hi, I;ve managed to create a loginModule with hardcoded users, although it works i want to be able to read the users and roles from a database but i'm not sure how to proceed. I've read the tutorials but it doesnt work for me. my loginconfig: DOCTYPE policy PUBLIC "-//JBoss//DTD JBOSS Security Config 3.0//EN" "http://www.jboss.org/j2ee/dtd/security_config.dtd" <application-policy name="testDB" <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required" <module-option name="dsJndiName">java:/MyDatabaseDS</module-option <module-option name="principalsQuery" select passwd from Users username where username=?</module-option <module-option name="rolesQuery" select userRoles, 'Roles' from UserRoles where username=?</module-option </login-module </application-policy jbossservice: <?xml version="1.0" encoding="UTF-8"? <!DOCTYPE server PUBLIC "-//JBoss//DTD MBean Service 4.0//EN" "http://www.jboss.org/j2ee/dtd/jboss-service_4_0.dtd" META-INF/login-config.xml <depends optional-attribute-name="LoginConfigService" jboss.security:service=XMLLoginConfig <depends optional-attribute-name="SecurityManagerService" jboss.security:service=JaasSecurityManager does anyone know how to read users from a database using jboss 4.2.x ? Thanks View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4123988#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...