Lists users in the catalog, optionally filtered by a LIKE pattern.
SHOW USERS [LIKE '<pattern>']## Overview SHOW USERS returns a row per user. The result includes the user's name, default role, disabled flag, and creation timestamp. ## Output | Column | Description | |--------|-------------| | name | User name | | default_role | Default role activated at sign-in | | disabled | Whether the user is disabled | | created_at | ISO 8601 timestamp | ## Access Control Requires the `ManageUsers` privilege. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
pattern | Optional LIKE pattern. SQL wildcards `%` and `_` are honored. |
SHOW USERS;SHOW USERS LIKE 'a%';