SHOW AUTHORIZATION authorization_object returns the definition of an authorization object.
-
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.