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;
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, 7 months agoPrasantSadangi
Most Recent 4 months, 2 weeks agod22770a
10 months, 1 week ago_yyukta
1 year, 5 months agoAlexbDku
2 years, 7 months agohalol
2 years, 8 months ago