• 

  Designing the most performant Row Level Security(RLS) schema in Postgres

  

  medium.com

  Designing the most performant Row Level Security(RLS) schema in Postgres

          The main hypothesis is that we should be able to prevent access to specific rows of data based on a policy. That means our application logic only has to worry about SELECT * FROM my_table and RLS will handle the WHERE user_id = my_user_id part automagically.
  

  2

Appears in lists (1)

• Issues #62 Aug 13, 2018

More like this (2)

• PostgreSQL Schema Design

  

  graphile.org

  • Read

  
• PostgreSQL Row Level Security, views and a lot of magic - Cybertec

  

  cybertec-postgresql.com

  Row Level Security, Views and a Lot of Magic — Row Level Security (RLS) is a...

  Row Level Security, Views and a Lot of Magic — Row Level Security (RLS) is a key Postgres feature that lets you define granular policies on which rows specific users can view or manipulate. Here’s a look at how they work and a problem Crunchy Data discovered with the feature.

  • Read