17.00 - Example: Using AuthorizationsV - Teradata Database

Teradata Vantage™ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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