File: create_row_access_policy.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (27 lines) | stat: -rw-r--r-- 892 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
 
CREATE ROW ACCESS POLICY
row_access_policy_name ON example_dataset.example_table
FILTER USING (TRUE);

CREATE OR REPLACE ROW ACCESS POLICY
row_access_policy_name ON example_dataset.example_table
GRANT TO ("user:someone@example.com")
FILTER USING (x = y);

CREATE ROW ACCESS POLICY IF NOT EXISTS
row_access_policy_name ON example_dataset.example_table
GRANT TO (
   "serviceAccount:example@example-project.iam.gserviceaccount.com",
   "group:some_group@example.com",
   "domain:example.com"
)
FILTER USING (email_column_name = SESSION_USER());

CREATE OR REPLACE ROW ACCESS POLICY IF NOT EXISTS
row_access_policy_name ON example_dataset.example_table
GRANT TO ("allAuthenticatedUsers")
FILTER USING (SESSION_USER() IN ("foo", "bar"));

CREATE ROW ACCESS POLICY
row_access_policy_name ON example_dataset.example_table
GRANT TO ("allUsers")
FILTER USING (example_dataset.exampleFunction(x, y));