access_time 4 months ago languageEnglish
more_vert

Teradata: Rights on a Database

visibility 16 comment 0

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.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more

More from Kontext