select * from depesz; » Blog Archive » Waiting for 9.5 – Row-Level Security Policies (RLS)

Blog Projects Contact Waiting for 9.5 – Row-Level Security Policies (RLS) October 2nd, 2014 by depesz | Tags: pg95 , postgresql , rls , row-level , security , sepostgresql | 8 comments » Did it help? If yes - maybe you can help me? Donate BTC to 19zPa5diT2LZqGtTi8f8bfApLn8rw9zBHx On 19th of September, Stephen Frost committed patch: 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 the with-check options of the query.   New top-level commands are CREATE/ALTER/DROP POLICY and are controlled by ...

Linked on 2015-03-11 23:46:50 | Similar Links