Re: [HACKERS] CREATE POLICY bug ?

2016-09-01 Thread Dean Rasheed
[Please reply to the list, not just to me, so that others can benefit from and contribute to the discussion] On 31 August 2016 at 11:52, Andrea Adami wrote: > Thnaks Dean, i did further investigations: > i set the owner of the view to: "mana...@scuola247.it" with: > ALTER TABLE

Re: [HACKERS] CREATE POLICY bug ?

2016-08-20 Thread Dean Rasheed
On 20 August 2016 at 03:15, Andrea Adami wrote: > when i run the query: "select * from public.policy_view" > the ouput is the same (all rows) for all users > i'm doing some mistakes or this is a bug ? > No, it looks correct to me. When going through a view, the policies and

[HACKERS] CREATE POLICY bug ?

2016-08-19 Thread Andrea Adami
Hello, i'm testing the new row security level functionality in postgresql 9.5. To do that i run this script: ---cut here -- CREATE TABLE public.policy_tab ( id bigint NOT NULL, description character varying(160) NOT NULL, usr name NOT NULL, CONSTRAINT