Teradata: Rights Held by Database

visibility 47 access_time 2 years ago languageEnglish

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';

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.10
More from Kontext
Truncate table in Teradata
visibility 1,457
thumb_up 0
access_time 3 years ago
Python: Save Pandas DataFrame to Teradata
visibility 8,047
thumb_up 1
access_time 2 years ago
Teradata LPAD - Left Padding
visibility 3,412
thumb_up 0
access_time 2 years ago