Categories:

User & Security DDL (Users)

# SHOW USERS¶

Lists all users in the system.

## Syntax¶

SHOW USERS [ LIKE '<pattern>' ]


## Parameters¶

LIKE 'pattern'

Filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ...
... LIKE '%TESTING%' ...

## Usage Notes¶

• The command can only be executed by users with a role that has the MANAGE GRANTS global privilege. This privilege is usually only granted to the ACCOUNTADMIN and SECURITYADMIN roles.

• The command does not require a running warehouse to execute.

• The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.

To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Information Schema.

• To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.