Can I simulate how a row access policy will work to make sure its working correctly with different scenarios and roles?
Frank Bell Answered question July 19, 2022
Next, define a policy with one or more conditions to query the mapping table with a subquery. At query runtime, Snowflake determines whether the user executing the query matches the sales region specified in the mapping table. If a match occurs, the user can see those rows in the query result. Based on the mapping table, the expected query results are as follows:
Frank Bell Answered question July 19, 2022
