Understanding Row Level Access Control | Snowflake Tutorial

[@KSrikanth-gy2pe]

Thanks for sharing, you put lots of effort to make this one. With this you gave detailed information..

[@SondreHonningsøy-r9i]

Using the mapping table approach, how would you do it if you want a third role in the mapping table that has access to everything? ie. you can't hardcode a specific country code because the user is supposed to see everything

[@mastering_snowflake]

Great question. In this instance your row access policy is a case statement. When the role which requires access to everything executes a query against the table then you don’t have a filter as part of the case statement for this role - meaning it returns everything.
I actually cover this specific example within the mastering snowflake program www.Masteringsnowflake.com

[@vishvas07]

Thanks!

[@yogeshbharadwaj6200]

very detailed...tks a lot...

[@abdullahsiddique7787]

First