Cloud Computing
  • 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;

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *