Kontext Copilot - An AI-powered assistant for data analytics that runs on your local computer. Learn more
Get started
Teradata SQL: Rights Held by Database
insights Stats
warning Please login first to view stats information.
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 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';
info Last modified by Raymond 3 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.