Skip to content

Instantly share code, notes, and snippets.

@daanalytics
Created April 26, 2023 09:48
Show Gist options
  • Save daanalytics/138d2244c3ee881ec54640d461aba616 to your computer and use it in GitHub Desktop.
Save daanalytics/138d2244c3ee881ec54640d461aba616 to your computer and use it in GitHub Desktop.
Load Mapping Table for Row Access Policy
-- INSERT INTO customer_loyalty_city_policy_mapping
-- VALUES ('<CITY_NAME>', '<ROLE_NAME>')
--;
--
INSERT INTO customer_loyalty_city_policy_mapping
VALUES ('Cape Town', 'TASTY_TEST_ROLE')
;
INSERT INTO customer_loyalty_city_policy_mapping
VALUES ('Barcelona', 'TASTY_BI')
;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment