17.05 - Using SHOW AUTHORIZATION - Teradata Database

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

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.05
created_date
January 2021
category
Programming Reference
featnum
B035-1214-175K

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.