DESCRIBE ROLE

Syntax

DESCRIBE ROLE role_name;

Description

This provides the description of an existing 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    |
+--------------+------------+----------------+--------------------+-------------+