Example: Using AllRoleRightsV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantage™

The following SELECT statement returns all the privileges granted to each role:

                 SELECT CAST(RoleName as CHAR(16)) as RoleName,
        CAST(DatabaseName as CHAR(15)) as Databases,
        CAST(TableName as CHAR(15)) as TVMs,
        CAST(AccessRight as CHAR(5)) as AccRights,
        CAST(GrantorName as CHAR(15)) as Grantor
                 FROM  DBC.AllRoleRightsV
                 WHERE RoleName like 'roles017%'
                 ORDER BY 1,2,3,5;

Result:

RoleName          Databases        TVMs             AccRights  Grantor
----------------  ---------------  ---------------  ---------  ---------------
roles017_dbc_r1b  roles017_3_db    roles017_3_m3    E          roles017_3
roles017_r1a      roles017_3_db    roles017_3_t1    R          roles017_3
roles017_r1c      roles017_3_db    roles017_3_t4    R          monthly
roles017_r1f      roles017_3_db    roles017_3_v2    R          roles017_3
roles017_r2d      roles017_3_db    roles017_3_v2    R          roles017_3
roles017_r2e      roles017_3_db    roles017_3_t5    R          monthly