Teradata SQL: Rights on a Database

Raymond Tang Raymond Tang 0 343 0.21 index 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

Join the Discussion

View or add your thoughts below

Comments