17.10 - Example: Using UserRightsV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

The following SELECT statement displays information about all tables in the Personnel database on which privileges were granted to the requesting user.

SELECT * FROM DBC.UserRightsV
       WHERE DatabaseName=’Personnel’
       AND TableName = ’All’ ;

Result:

DatabaseName   TableName     AccessRight     GrantorName
------------   ---------     -----------     -----------
Personnel      Employee            R          DBC
Personnel      Employee            U          DBC
Personnel      Employee            I          DBC