17.10 - Example: Using AuthorizationsV - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

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