IS_ORGANIZATION_USER_GROUP

Returns TRUE if the specified role was created when an administrator added an organization user group to the account.

Syntax

IS_ORGANIZATION_USER_GROUP( '<role>' )
Copy

Arguments

'role'

Role in the current account.

Returns

Returns TRUE if the specified role was created from or linked to an organization user group.

Usage notes

In data sharing contexts, this function returns NULL if it is called from a consumer account that exists in a different organization than the provider account. Calling the function from a consumer account in the same organization as the provider returns TRUE or FALSE.

Examples

Determine if the role data_stewards in the current account was created from an organization user group.

SELECT IS_ORGANIZATION_USER_GROUP('data_stewards');
Copy