]> granicus.if.org Git - postgresql/commit
RLS: Keep deny policy when only restrictive exist
authorStephen Frost <sfrost@snowman.net>
Mon, 3 Aug 2015 19:32:49 +0000 (15:32 -0400)
committerStephen Frost <sfrost@snowman.net>
Mon, 3 Aug 2015 19:32:49 +0000 (15:32 -0400)
commitdee0200f0276c0f9da930a2c926f90f5615f2d64
treeeae2bb8d8694ae6bd2efd6faaa37d035cb79fd1e
parentecc2d16bc97d160d3b4beecfc46676bbaaf157a5
RLS: Keep deny policy when only restrictive exist

Only remove the default deny policy when a permissive policy exists
(either from the hook or defined by the user).  If only restrictive
policies exist then no rows will be visible, as restrictive policies
shouldn't make rows visible.  To address this requirement, a single
"USING (true)" permissive policy can be created.

Update the test_rls_hooks regression tests to create the necessary
"USING (true)" permissive policy.

Back-patch to 9.5 where RLS was added.

Per discussion with Dean.
src/backend/rewrite/rowsecurity.c
src/test/modules/test_rls_hooks/expected/test_rls_hooks.out
src/test/modules/test_rls_hooks/sql/test_rls_hooks.sql
src/test/modules/test_rls_hooks/test_rls_hooks.c