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;