Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Row-level Security Error

I followed the documentation on row-level security but running the following DDL statements grants access to both column_value_1 and column_value_2 to user_1. this shouldn't happen. what am I doing wrong?

 

CREATE ROW ACCESS POLICY policy_1
ON `project.dataset.table_1`
GRANT TO ('user:user_1@google.com')
FILTER USING (column IN ('column_value_1'));
 
CREATE ROW ACCESS POLICY policy_2
ON `project.dataset.table_1`
GRANT TO ('user:user_2@google.com')
FILTER USING (column IN ('column_value_2'));
0 3 172
3 REPLIES 3