Within a Snowflake account, permissions have been defined using custom roles and role hierarchies.
To configure column-level masking by using a role in the current user's hierarchy, which command would be used?
IS_ROLE_IN_SESSION verifies whether a specified account role is in the active primary or secondary role hierarchy of the current user’s session. Snowflake recommends this function in masking-policy conditions when role hierarchy and inherited privileges must be evaluated.
IS_ROLE_IN_SESSION
Community Discussion