I am using JBoss3.2 J_Security feature for roles management. In jboss's login-config.xml file.I have specified query to retrieve roles as below.
<authentication>
<login-module code = "org.jboss.security.auth.spi.DatabaseServerLoginModule"
flag = "required" >
<module-option name="dsJndiName">java:/RAMSDataSource</module-option>
<module-option name="rolesQuery">SELECT DISTINCT(SYSROLE) 'Roles' , 'Roles' AS 'RoleGroups' FROM Roles(NOLOCK) where userid=?</module-option>
</login-module>
</authentication>
Problem I am facing is that if i update roles for a user in corresponding table.JBOss doesn't reflect corresponding changes untill i restart Jboss.
Am i missing some attribute to set.