Within a Snowflake account. permissions have been defined with custom roles and role hierarchies.
To set up column-level masking using a role in the hierarchy of the current user, what command would be used?
Within a Snowflake account. permissions have been defined with custom roles and role hierarchies.
To set up column-level masking using a role in the hierarchy of the current user, what command would be used?
To set up column-level masking using a role in the hierarchy of the current user, the INVOKER_ROLE command would be used. This command is specifically designed to handle role-based security, allowing operations to be performed using roles that are in the current user's role hierarchy. It ensures that roles execute SQL statements with the right privileges, avoiding potential security issues.
More info here https://docs.snowflake.com/en/user-guide/security-column-intro
https://docs.snowflake.com/en/sql-reference/functions/is_granted_to_invoker_role