Teradata SQL: Rights on a Database

event 2021-01-19 visibility 283 comment 0 insights
more_vert
insights Stats
Raymond Raymond Code Snippets & Tips

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise. 

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
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts