Teradata SQL: Rights on a Database

Raymond Tang Raymond Tang 350 1/19/2021

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

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

Code snippet

select * from dbc.allrights
where DatabaseName='TestDb2';

The above code snippet returns all the access rights on a database container TestDb2.

teradata