I am having similar problem, when i change roles of a user, he logs out and logs in back, he still has access to the modules which were mapped to his earlier roles.
When i tried to delete that user i got this error: anonymous wrote : 2009-02-17 16:37:30,904 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000 | 2009-02-17 16:37:30,905 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-02292: integrity constraint (B2BPORTALADMIN26.FKF410173866F4DA65) violated - child record found | | 2009-02-17 16:37:30,905 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 2292, SQLState: 23000 | 2009-02-17 16:37:30,906 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-02292: integrity constraint (B2BPORTALADMIN26.FKF410173866F4DA65) violated - child record found | | 2009-02-17 16:37:30,907 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session | org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253) when i tried to delete the user second time, the user got deleted. I created the user again and now his new roles are working, but i have lost confidence in the Role based access provided by portal. Any remedies for this kind of issue .. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4210898#4210898 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4210898 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
