Postgres 9.5 feature highlight: Row-Level Security and Policies

Header part with title and page menus Michael Paquier - Open source developer based in Japan List all page top items About Home Manuals Presentations Projects Resume Main content column Print content in presence of a post 03 Oct 2014 Row-level security is a new feature of PostgreSQL 9.5 that has been introduced by this commit: commit: 491c029dbc4206779cf659aa0ff986af7831d2ff author: Stephen Frost <sfrost@snowman.net> date: Fri, 19 Sep 2014 11:18:35 -0400 Row-Level Security Policies (RLS) Building on the updatable security-barrier views work, add the ability to define policies on tables to limit the set of rows which are returned from a query and which are allowed to be added to a table. Expressions defined by the policy for filtering are added to the security barrier quals of the query, while expressions defined to check records being added to a table are added to t...

Linked on 2014-10-03 18:49:38 | Similar Links