17.05 - Using SHOW AUTHORIZATION - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Native Object Store Getting Started Guide

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1214-175K
Language
English (United States)

SHOW AUTHORIZATION authorization_object returns the definition of an authorization object.

  1. Show the definition of the authorization object.
    SHOW AUTHORIZATION authorization_object;

    See Variable Substitutions for Examples for the credentials and location values for the sample river flow data set.

    For example:

    SHOW AUTHORIZATION NOS_USR.DefAuth;

    Result:

    CREATE AUTHORIZATION NOS_USR.DefAuth
    AS DEFINER TRUSTED
    USER 'YOUR-ACCESS-KEY-ID';

    Note, the password is not returned.