row security Archives - 2ndQuadrant

Posts

Emulating row security in PostgreSQL 9.4

December 9, 2015/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

PostgreSQL 9.5 adds declarative row security. You can declare policies on tables and have them enforced automatically – for example, allowing user joe to only see rows with the owner column equal to joe. This is a great feature, and it’s been a long time coming. It didn’t make it into PostgreSQL 9.4, but automatically […]

Row security in PostgreSQL – Overview

February 26, 2014/5 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

In the next week I will be writing a series of posts about the row-security work I’ve been doing for PostgreSQL 9.4 as part of the EU’s AXLE project. I will be outlining the history, approaches tried, current status, remaining issues, and future work required. To open the series, I’d like to talk about what […]

How do PostgreSQL security_barrier views work?

November 7, 2013/8 Comments/in Craig's PlanetPostgreSQL, PostgreSQL /by craig.ringer

You might have seen the support added for security_barrier views in PostgreSQL 9.2. I’ve been looking into that code with an eye to adding automatic update support for them as part of progressing row-level security work for the AXLE project, and I thought I’d take the chance to explain how they work. Robert already explained […]

Posts

Support & Services

Products

Postgres Learning Center

About Us