Object owners (i.e. the role that has the OWNERSHIP privilege on the object) do not have the privilege to unset masking policies.
Object owners cannot view column data in which a masking policy applies.
https://docs.snowflake.com/en/user-guide/security-column-intro.html#what-are-masking-policies
https://docs.snowflake.com/en/user-guide/security-column-intro#what-are-masking-policies
Object owners (i.e. the role that has the OWNERSHIP privilege on the object) do not have the privilege to unset masking policies.
Object owners cannot view column data in which a masking policy applies.
The question here is Will the developer be able to modify the table to read the masked data?
It is about modifying the table to read the data from masked column.
Owner of the table can definitely UNSET the masking policy by using this command
ALTER TABLE <name> modify column <col_name> unset masking policy;
OWNERSHIP
Grants full control over the masking policy. Required to alter most properties of a masking policy. Only a single role can hold this privilege on a specific object at a time.
Object owners (i.e. the role that has the OWNERSHIP privilege on the object) do not have the privilege to unset masking policies.
Object owners cannot view column data in which a masking policy applies.
https://docs.snowflake.com/en/user-guide/security-column-intro.html#what-are-masking-policies
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
miadiesel
Highly Voted 2 years, 4 months agoPrasantSadangi
Most Recent 1 month, 1 week agod22770a
7 months ago_yyukta
1 year, 2 months ago[Removed]
1 year, 6 months agoAlexbDku
2 years, 4 months agohalol
2 years, 4 months ago