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.
CREATE ORGANIZATION USER GROUP , ALTER ORGANIZATION USER GROUP , DROP ORGANIZATION USER GROUP
SHOW ORGANIZATION USER GROUPS
Copy
Parameters¶None
Access control requirements¶The access control requirements for this command vary depending on the account where it is being executed.
Executing this command in a regular account requires the ACCOUNTADMIN role.
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 and USERADMIN system roles in the organization account have 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.
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 group.
is_imported
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.
created_on
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;
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4