15.10 - AllRightsV[X] - 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)

Accounting

DBC

 

View Column

Data Type

Format

Source Table.Column

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

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

GrantAuthority

CHAR(1)

LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

AccessRights.WithGrant

GrantorName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DataBaseNameI (UPI)

AllnessFlag

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

AccessRights.AllnessFlag

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DataBaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

AccessRights.CreateTimeStamp

The X view references these additional tables:

  • DBC.Owners
  • DBC.Roles
  • DBC.RoleGrants
  • The AllRights view does not contain information about implicit privileges for a user, only explicit privileges granted on the object. For information about the types of explicit privileges, see “AccessRight Column” in Appendix A: “View Column Values.”

    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