15.10 - AuthorizationsV[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)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

DataBaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

AuthorizationName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName

AuthorizationId

BYTE(6)

NOT NULL

X(12)

TVM.TVMId

TableKind

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

TVM.TableKind

Version

SMALLINT

NOT NULL

---,--9 (explicit)

TVM.Version

AuthorizationType

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

TVM.AuthorizationType

AuthorizationSubType

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

X(1)

TVM.AuthorizationSubType

OSDomainName

VARCHAR(256) LATIN

CASESPECIFIC

X(256)

TVM.OSDomainName

OSUserName

VARCHAR(256) LATIN

CASESPECIFIC

X(256)

TVM.OSUserName

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owner
  • For information about the possible values for the TableKind column, see Appendix A: “View Column Values.”

    Possible Values for AuthorizationName

    If AuthorizationType is I, two entries appear for the same database name: one where AuthorizationName is the same as the name specified in the CREATE AUTHORIZATION statement and one where AuthorizationName is a default name.

    Possible Values for AuthorizationSubType

     

    Value

    Description

    D

    Default

    N

    Non-default

    Possible Values for AuthorizationType

     

    Value

    Description

    D

    Definer

    I

    Invoker

    T

    Invoker Trusted

    S

    Definer Trusted

    The following SELECT statement returns details about the database DBA.

    ==> SELECT * FROM AuthorizationsV WHERE databasename = 'dba';

    Result:

        DatabaseName dba
      AuthorizationName INVOKER_DEFAULT
       AuthorizationId 00001F0A0000
          TableKind X
           Version 1
      AuthorizationType I
    AuthorizationSubType D
        OSDomainName
         OSUserName gdUsrGrp
        DatabaseName dba
      AuthorizationName myinvoker
       AuthorizationId 00001E0A0000
          TableKind X
           Version 1
      AuthorizationType I
    AuthorizationSubType D
        OSDomainName
         OSUserName gdUsrGrp