Role Security

Does anyone know of a report that can list all roles and the users assigned to the roles? Also, what table has the role relationship?

Thanks!

B8.9 SP2 WINDOWS\SQL 2K

There are no reports that are delivered with OneWorld that give you that. However, it's a very simple report to create. The table for the relationships is F9001. However, there are a few other tables that tie to that particular table for SE roles. They are F9000, F9001, F9002, F9005, F9006 and F9010.

The relationships for User to group is in F0092.

F0092 only has the role and user id's. The other table mentioned sit on the data databases. I cannot find any relationship between role and user. Since security is in the system DB why would the F9000 tables have security info?

winterc,

Please look in the F95921 table, which is the Role Relationship table.
This should get you the information you need.

True, my last post mentioned the F9000 tables. Those are used for Solution Explorer tasks and their relationships to Roles. My bad. Sorry.

Thanks Mr. Sauve! This is what I was looking for!