16.20 - Example: Using UserRoleRightsV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

The following SELECT statement returns all privileges granted to the current role of the user and the roles nested within the current role.

SELECT CAST(RoleName as CHAR(16)) as RoleName,
       CAST(DatabaseName as CHAR(15)) as Databases,
       CAST(TableName as CHAR(15)) as TVMs,
       CAST(ColumnName as CHAR(10)) as Columns,
       CAST(AccessRight as CHAR(5)) as AccRights,
       CAST(GrantorName as CHAR(15)) as Grantor
    FROM DBC.UserRoleRightsV
    ORDER BY 1,2,3,5;

Result:

RoleName        Databases        TVMs             AccRights  Grantor
--------------  ---------------  ---------------  ---------  ---------
roles017_r1f    roles017_3_db    roles017_3_v2    R          roles017_3
roles017_r2d    roles017_3_db    roles017_3_v2    R          roles017_3