Organization user and organization user group functions

The following functions help you work with organization users and organization user groups.

FunctionDescription
CURRENT_ORGANIZATION_USERIndicates whether the current user in the session was imported from an organization user.
IS_ORGANIZATION_USER,
IS_USER_IMPORTED (SYS_CONTEXT function)
Tests whether a specific user was imported from an organization user.
IS_ORGANIZATION_USER_GROUP,
IS_GROUP_IMPORTED (SYS_CONTEXT function)
Tests whether a specific role was imported from an organization user group.
IS_ORGANIZATION_USER_GROUP_IN_SESSION,
IS_GROUP_ACTIVATED (SYS_CONTEXT function)
Tests whether a specific imported role is in the role hierarchy of the user’s current session.
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION namespace)Returns information about organization users and organization user groups.
SYS_CONTEXT (SNOWFLAKE$ORGANIZATION_SESSION namespace)Returns information about the current session and the current organization user in the session.
SYSTEM$LINK_ORGANIZATION_USERLinks an organization user with an existing user object so it can be managed as an organization user going forward.
SYSTEM$LINK_ORGANIZATION_USER_GROUPLinks an organization user group with an existing access control role so it can be managed as a organization user group going forward.
SYSTEM$UNLINK_ORGANIZATION_USERUnlinks a user object from an organization user so it can be managed as a local user going forward.
SYSTEM$UNLINK_ORGANIZATION_USER_GROUPUnlinks an access control role from an organization user group so it can be managed as a local role going forward.