17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

For information about the possible values for the TableKind column, see "TableKind Column."

Corresponding Tables

The X view references these additional tables:
  • DBC.AccessRights
  • DBC.Owner

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