SHOW ROLES IN SERVICE

Lists all the service roles associated with a service. These are the roles defined in the service specification. For more information, see Managing access to service endpoints.

See also:

REVOKE SERVICE ROLE, GRANT SERVICE ROLE, SHOW GRANTS

Syntax

SHOW ROLES IN SERVICE <name>
Copy

Parameters

name

Name of the service.

Access control requirements

A role used to execute this operation must have the following privileges at a minimum:

Privilege

Object

Notes

USAGE

Service

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Output

The command output provides the following columns:

Column

Description

created_on

Date and time when the service role was created

name

Service role name

comment

Comment, if any, for the service role

Usage notes

  • The command doesn’t require a running warehouse to execute.

  • The command only returns objects for which the current user’s current role has been granted at least one access privilege.

  • The MANAGE GRANTS access privilege implicitly allows its holder to see every object in the account. By default, only the account administrator (users with the ACCOUNTADMIN role) and security administrator (users with the SECURITYADMIN role) have the MANAGE GRANTS privilege.

  • 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 the service roles in the echo_service service.

SHOW ROLES IN SERVICE echo_service;
Copy
+-------------------------------+-------------------------+------------+
| created_on                    |   name                      |  comment   |
+-------------------------------+-------------------------+------------+
| 2024-04-29 14:58:50.063 -0700 |   ALL_ENDPOINTS_USAGE   |            |
+-------------------------------+-------------------------+------------+
Language: English