15.10 - AllRoleRightsV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

RoleName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Roles.RoleName

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

ColumnName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVFields.FieldName

AccessRight

CHAR(2) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(2)

AccessRights.AccessRight

GrantorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DataBaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

AccessRights.CreateTimeStamp

The AllRollRightsV view also references the DBC.Owners table.

The AllRoleRightsV view is similar to the AllRightsV view except that it does not include the following columns:

  • AllnessFlag
  • CreatorName column
  • For information about the possible values for the AccessRight column, see Appendix A: “View Column Values.”

    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