- To view who are the users in the complete database environment .
sel * from dbc.users;
- To view the type of roles granted to a user.
sel * from dbc.rolemembers where grantee='<username>’;
- To view the access of a individual role
sel * from dbc.allrolerights where rolename='<Role Name>’;
- To view all the access throughout the database
sel * from dbc.allaccessrights;