I use Bigquery to query data and RLS has been implemented to my tables. I created a table and joined 2 different tables, with respectively C1 and C2 security : how the RLS is handled with a joined table ? My new table has a C1 or a C2 security (C2 is more restrictive than C1) ?
Best Regards, Rinn
RLS of the resulting table will be determined by the most restrictive security level of the joined tables. In this case, the new table will inherit the C2 security level. This is just because the joined table most likely contains information from the more restrictive table (C2), so it must be protected at least as strictly as that table.