Skip to content
Developer Edition runs on one host and does not require a product license file. Need multi-host deployment or performance testing at scale? Explore Enterprise Edition

SHOW USERS command

The SHOW USERS command returns all users that are invited to the current service group. For more information, see INVITE USER.

After a user is invited to a service group, you must grant the user the CONNECT action on the service group before the user can access it. For more information, see Authorization overview.

The following table describes the returned information:

Column Description
name The name of the user who is invited to the current service group.
home_schema The path of the home schema set for the user. For more information, see ALTER USER SET HOME_SCHEMA.
home_graph The name of the home graph set for the user. The value is empty if no home graph is set. For more information, see ALTER USER SET HOME_GRAPH.
invited_time The time when the user was invited to the current service group.

Syntax

show_users
SHOW USERS 

show_users ::=
    'SHOW' 'USERS'

Examples

SHOW USERS

Return:

+-------+------------------+-----------------+----------------------------- +
| name  |   home_schema    |   home_graph    | invited_time                 |
+-------+------------------+-----------------+----------------------------- +
| root  | /default_schema  |                 | 2025-10-20T02:08:32.703000Z  |
| user1 | /default_schema  |                 | 2025-10-20T02:11:21.528000Z  |
+-------+------------------+-----------------+----------------------------- +