16.20 - Example: Using AllRightsV - 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 displays the privileges user Jones has on tables:

SELECT Tablename, AccessRight, GrantorName
       FROM DBC.AllRightsV WHERE UserName = ’Jones’;

Result:

TableName           AccessRight          GrantorName
----------          -----------          -------------
project             RS                   SYSTEMAD
project             DP                   SYSTEMAD
project             DT                   SYSTEMAD
project             D                    SYSTEMAD
project             I                    SYSTEMAD
project             U                    SYSTEMAD
project             R                    SYSTEMAD
employee            I                    SYSTEMAD
employee            U                    SYSTEMAD