DESCRIBE ROLE

Syntax

DESCRIBE ROLE role_name;

Description

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

Roles are visible only if the current role has USAGE privileges on the role.

Arguments

role_name

Name of the role to describe. If the name is case-sensitive, you must wrap it in double quotes; otherwise, the system uses the lowercase name.

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    |
+--------------+------------+----------------+--------------------+-------------+