Teradata SQL: Rights Held by Database

Raymond Tang Raymond Tang 0 262 0.16 index 1/19/2021

Teradata Administrator tool used to have a function to show rights held by a database.

You can also directly use SQL to query that instead of relying on the GUI tool.

Rights held by a database

select * from dbc.allrights
where UserName='TestDb';

The above code snippet returns all the access rights held by database container TestDb.

Rights held by a user

For Teradata, a user is also a database. Thus you can use same SQL to query rights held by a database user:

select * from dbc.allrights
where UserName='DBC';
teradata

Join the Discussion

View or add your thoughts below

Comments