PGCon2015 - final

PGCon 2015
The PostgreSQL Conference

Stephen Frost
Day Talks - Day 4 - Friday - 2015-06-19
Room DMS 1140
Start time 16:00
Duration 00:45
ID 823
Event type Lecture
Track 9.5 Features
Language used for presentation English

Row Level Security

In this talk we'll review Row-Level Security (RLS), provide examples and use-cases, discuss the work which has been done on adding Row Level Security to PostgreSQL and the current state of that effort.

PostgreSQL has long had a complex and interesting set of permissions available through the GRANT system. There is another system which exists in many other RDBMS's known as row-level security (RLS), where the rows returned is filtered based on a policy implemented on the table.