2023-10-27 - Row Level Security¶
Problem¶
Originally policy names were based on the column that the policy was applued to. This wasn’t a scalable pattern as a column can have multiple policies associated with it.
Solution¶
Extend the new table_policies table to include a guid (policy_id) which we use for the unqiue policy name when creating them on a table.
Leverage the Magic¶
A small tweak to the spanner backend and the /policies api to set the policy_id guid when we create or update a table policy
Last Refreshed¶
Doc Refreshed: 2024-05-20