Teradata SQL: Rights on a Database

visibility 102 event 2021-01-19 access_time 26 days ago language English
more_vert

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

info Last modified by Raymond 26 days ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts