A company's Snowflake account has multiple roles.

create or replace row access policy region policy as (region_value varchar) returns boolean ->

'ALL ACCESS_ROLE' = current_role ()

and exists (

select 1 from entitlement_table

where role = current_role ()

and region = region_value

)

create or replace row access policy region policy as (region_value varchar) returns boolean ->

exists (

select 1 from entitlement_table

where role = current_role ()

and region = region_value

)

create or replace row access policy region policy as (region_value varchar) returns boolean ->

'ALL_ACCESS_ROLE' = current_role ()

or exists (

select 1 from entitlement_table

where role = current_role ()

and region = region_value

)

create or replace row access policy region policy as (region_value varchar) returns boolean ->

'ALL ACCESS ROLE' = current_role ()

)