PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

Details for Access & Access Rights for a User in Teradata

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

Add a Comment

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