Teradata: Rights on a Database

visibility 56 access_time 2 years ago languageEnglish

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

copyright This page is subject to Site terms.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

timeline Stats
Page index 0.11
More from Kontext
Teradata Role Access on Databases
visibility 176
thumb_up 0
access_time 12 months ago
Truncate table in Teradata
visibility 1,466
thumb_up 0
access_time 3 years ago
Teradata: PIVOT and UNPIVOT Clause
visibility 1,006
thumb_up 0
access_time 10 months ago