Row Level Security
Presented by:
Stephen Frost
Stephen Frost is the Chief Technology Officer for Crunchy Data Solutions, Inc.
Stephen is a PostgreSQL Committer and Major Contributor, his previous work has included implementing the role system in 8.1 (replacing the previous user/group system), column-level privileges in 8.4 and improvements to PL/pgSQL.
No video of the event yet, sorry!
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. In this talk we'll review 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.
- Date:
- Duration:
- 30 min
- Room:
- Conference:
- PGConf US 2015 [PgConf.US]
- Language:
- Track:
- Security
- Difficulty:
- Medium