All access details for a database

Database
Enthusiast

All access details for a database

Hi,

Is there a way to get all access details for a database DB.I want list of all users who can access it from direct ,through role and by indirect database access(users who dont have direct access to DB but have access through some other database).

1 REPLY
Enthusiast

Re: All access details for a database

Try Join : dbc.allrights,dbc.allrolerights and dbc.rolemembers.