.. _2023-10-27-row-level-security-_release:

=================================================================================
2023-10-27 - Row Level Security 
=================================================================================

Release
==================
*Status: Available*

*Type: DataOps*

*Date: 2023-10-27*

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-03-02*