Teradata SQL: Rights on a Database

Raymond Raymond
Raymond
Stats
articleArticles 555
codeCode 5
imageDiagrams 54
descriptionNotebooks 0
chat_bubble_outlineThreads 8
commentComments 296
loyaltyKontext Points 6181
account_circle Profile
visibility 160 event 2021-01-19 access_time 2 years ago language English
share
Twitter Facebook LinkedIn
more_vert
arrow_upward arrow_downward

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. 

More from Kontext
info Last modified by Raymond 2 years ago copyright This page is subject to Site terms.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts