DESCRIBE ROLE

Syntax

DESCRIBE ROLE role_name;

Description

This command provides the description of an existing Role in the current Organization.

Roles will only be visible if the current role has USAGE privileges on the Role.

Arguments

role_name

Name of the role to describe. For case-sensitive names, the name must be wrapped in double quotes; otherwise, the lowercase name will be used.

Examples

<no-db>/<no-store># DESCRIBE ROLE useradmin;
+--------------+------------+----------------+--------------------+-------------+
|  Type        |  Name      |  Privilege     |  With Grant Option |  Granted By |
+==============+============+================+====================+=============+
| role         | public     | usage          | false              | orgadmin    |
+--------------+------------+----------------+--------------------+-------------+
| organization | useradmin  | manage_members | true               | orgadmin    |
+--------------+------------+----------------+--------------------+-------------+