What happens when a table has BOTH a data masking policy and a row access policy applied to it? Does it use both?

103 viewsSecurity in SnowflakeRow Access Policies
0

What happens when a table has BOTH a data masking policy and a row access policy applied to it? Does it use both?

Frank Bell Answered question May 22, 2022
0

Yes. The way it works though is that Snowflake EVALUATES the Row Access Policy FIRST and then the data masking policy. Also, realize that if you do have BOTH a row access policy and data masking policy associated with the SAME table then they CANNOT reference the same exact column.

Frank Bell Answered question May 22, 2022