16.20 - Example: Using AuthorizationsV - 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 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