SHOW ORGANIZATION USER GROUPS¶
Lists organization user groups.
If the command is executed in the organization account, it lists all organization user groups in the organization.
If the command is executed in a regular account, it lists the organization user groups that are available to the account.
- See also:
CREATE ORGANIZATION USER GROUP , ALTER ORGANIZATION USER GROUP , DROP ORGANIZATION USER GROUP
Syntax¶
SHOW ORGANIZATION USER GROUPS
Parameters¶
None
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 USER GROUPS
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 of the organization user group. |
|
When executed from a regular account, indicates whether the organization user group has been added to the account successfully. If TRUE, the organization user group was added and the role of the same name created. |
|
Data and time when the organization user group was created. |
Examples¶
Show information about the organization user groups in the organization:
SHOW ORGANIZATION USER GROUPS;