CREATE ORGANIZATION USER GROUP¶

See also:: ALTER ORGANIZATION USER GROUP , DROP ORGANIZATION USER GROUP , SHOW ORGANIZATION USER GROUPS

Syntax¶

CREATE ORGANIZATION USER GROUP [ IF NOT EXISTS ] <name>
  [ IS_GRANTABLE = { TRUE | FALSE } ]

Copy

Required parameters¶

name

Identifier for the organization user group; must be unique for your organization.

The identifier must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (for example, "My object"). Identifiers enclosed in double quotes are also case sensitive.

For more information, see Identifier requirements.

Optional parameters¶

IS_GRANTABLE = { TRUE | FALSE }

Specifies whether the role that is imported into a regular account from the organization user group can be granted to an account-specific role. If TRUE, the role that is created when the ACCOUNTADMIN imports the organization user group can be granted to another role.

Default: FALSE

Access control requirements¶

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

Privilege	Object	Notes
CREATE ORGANIZATION USER GROUP	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.

Examples¶

Create an organization user group named data_stewards:

CREATE ORGANIZATION USER GROUP data_stewards;

Copy