Company
Date Published
Author
Jimmy Guerrero
Word count
530
Language
English
Hacker News points
None

Summary

In the latest YugabyteDB 2.0.6 release, PostgreSQL's row level security feature is supported out-of-the-box, allowing users to set policies that restrict access to specific rows of data in a table, with applications like customer or financial data being particularly useful for blocking access due to legal, liability, or compliance concerns. Users can create roles and grant privileges to those roles on tables, and then enable row level security on the table, creating policies that limit access to specific conditions such as employee_id values. This feature is available in YugabyteDB's SQL API and drivers, which are compatible with PostgreSQL wire protocol. With this feature, users can ensure data protection and compliance while developing applications using YugabyteDB.