SHOW DELEGATED AUTHORIZATIONS¶
Lists the active delegated authorizations for which you have access privileges. This command can be used to list the DELEGATED AUTHORIZATIONS for a specified user or integration (or the current user), or your entire account.
Syntax¶
SHOW DELEGATED AUTHORIZATIONS
SHOW DELEGATED AUTHORIZATIONS BY USER <username>
SHOW DELEGATED AUTHORIZATIONS TO SECURITY INTEGRATION <integration_name>
Variants¶
SHOW DELEGATED AUTHORIZATIONS BY USER username
Lists all the active delegated authorizations that have been approved by a user. This variant requires the MODIFY privilege on the user.
SHOW DELEGATED AUTHORIZATIONS TO SECURITY INTEGRATION integration_name
Lists all the active delegated authorizations that have been approved for an integration. This variant requires the ACCOUNTADMIN role.
For more details on each of these variants, see:
Usage notes¶
Columns that start with the prefix
is_
return eitherY
(yes) orN
(no).The command does not require a running warehouse to execute.
The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.
To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Snowflake Information Schema.
To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.
Examples¶
List all delegated authorizations for your account:
SHOW DELEGATED AUTHORIZATIONS; +-------------------------------+-----------+-----------+-------------------+--------------------+ | created_on | user_name | role_name | integration_name | integration_status | |-------------------------------+-----------+-----------+-------------------+--------------------| | 2018-11-27 07:43:10.914 -0800 | JSMITH | PUBLIC | MY_OAUTH_INT1 | ENABLED | | 2018-11-27 08:14:56.123 -0800 | MJONES | PUBLIC | MY_OAUTH_INT2 | ENABLED | +-------------------------------+-----------+-----------+-------------------+--------------------+Copy
List all delegated authorizations for a specified user:
SHOW DELEGATED AUTHORIZATIONS BY USER jsmith; +-------------------------------+-----------+-----------+-------------------+--------------------+ | created_on | user_name | role_name | integration_name | integration_status | |-------------------------------+-----------+-----------+-------------------+--------------------| | 2018-11-27 07:43:10.914 -0800 | JSMITH | PUBLIC | MY_OAUTH_INT1 | ENABLED | +-------------------------------+-----------+-----------+-------------------+--------------------+Copy
List all delegated authorizations for a specified integration:
SHOW DELEGATED AUTHORIZATIONS TO SECURITY INTEGRATION my_oauth_int2; +-------------------------------+-----------+-----------+-------------------+--------------------+ | created_on | user_name | role_name | integration_name | integration_status | |-------------------------------+-----------+-----------+-------------------+--------------------| | 2018-11-27 08:14:56.123 -0800 | MJONES | PUBLIC | MY_OAUTH_INT2 | ENABLED | +-------------------------------+-----------+-----------+-------------------+--------------------+Copy