views:

20

answers:

0

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.