DESCRIBE USER

Syntax

DESCRIBE USER 'email_address';

Description

Describe a #_user and their information, including name, email, and granted #_roles.

Arguments

email_address

The email address associated with the user.

Examples

Describe user

<no-db>/<no-store># DESCRIBE USER '[e-mail]';
+------------+-------------+------------+-------------------------------+-------------------------------+
|  Role Name |  Granted By |  Inherited |  Updated At                   |  Created At                   |
+============+=============+============+===============================+===============================+
| orgadmin   | orgadmin    | false      | 2023-09-19 16:17:03 +0000 UTC | 2023-09-19 16:17:03 +0000 UTC |
+------------+-------------+------------+-------------------------------+-------------------------------+
| public     | orgadmin    | true       | 2023-09-19 16:17:03 +0000 UTC | 2023-09-19 16:17:03 +0000 UTC |
+------------+-------------+------------+-------------------------------+-------------------------------+
| securityad | orgadmin    | true       | 2023-09-19 16:17:03 +0000 UTC | 2023-09-19 16:17:03 +0000 UTC |
| min        |             |            |                               |                               |
+------------+-------------+------------+-------------------------------+-------------------------------+
| sysadmin   | orgadmin    | true       | 2023-09-19 16:17:03 +0000 UTC | 2023-09-19 16:17:03 +0000 UTC |
+------------+-------------+------------+-------------------------------+-------------------------------+
| useradmin  | orgadmin    | true       | 2023-09-19 16:17:03 +0000 UTC | 2023-09-19 16:17:03 +0000 UTC |
+------------+-------------+------------+-------------------------------+-------------------------------+