SHOW ORGANIZATION USERS¶

Lists organization users. Administrators in the organization account can use this command to list all organization users in the organization. Administrators in a regular account use this command to list all organization users in a specific organization user group that was added to the account.

See also:: CREATE ORGANIZATION USER , ALTER ORGANIZATION USER , DROP ORGANIZATION USER

Syntax¶

SHOW ORGANIZATION USERS [ IN ORGANIZATION USER GROUP <org_user_group> ]

Copy

Parameters¶

IN ORGANIZATION USER GROUP org_user_group

Name of an organization user group. This command displays all of the organization users in the specified group.

Required when the command is executed by the account administrator in a regular account.

Access control requirements¶

The access control requirements for this command vary depending on the account where it is being executed.

Regular account:

Executing this command in a regular account requires the ACCOUNTADMIN role.

Organization account:

A role used to execute this operation must have the following privileges at a minimum:

Privilege	Object	Notes
MANAGE ORGANIZATION USERS	Account	By default, only the GLOBALORGADMIN has this privilege.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Output¶

The output of the command includes the following columns, which describe the properties and metadata of the object:

Column	Description
`name`	Name of the organization user.
`created_on`	Date and time when the organization user was created.
`is_imported`	When executed from a regular account, indicates whether the organization user in the specified organization user group was successfully imported.
`display_name`	Name displayed for the user in Snowsight.
`login_name`	Name that the user enters to log into the system.
`first_name`	First name of the organization user.
`middle_name`	Middle name of the organization user.
`last_name`	Last name of the organization user.
`email`	Email address of the organization user.
`comment`	User-specified description of the organization user object.

Examples¶

As an organization administrator, list all of the organization users in the organization:

USE ROLE GLOBALORGADMIN;

SHOW ORGANIZATION USERS;

Copy

As an account administrator, show information about the organization users in the organization user group data_stewards:

USE ROLE ACCOUNTADMIN;

SHOW ORGANIZATION USERS IN ORGANIZATION USER GROUP data_stewards;

Copy