Re: [GENERAL] Row level security - notes and questions

2015-07-11 Thread Charles Clavadetscher
: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Row level security - notes and questions > > Charles, > > * Charles Clavadetscher (clavadetsc...@swisspug.org) wrote: > > I have been testing the new row level security feature of 9.5 and I > > have some notes and

Re: [GENERAL] Row level security - notes and questions

2015-07-11 Thread Adrian Klaver
On 07/10/2015 10:28 PM, Charles Clavadetscher wrote: Hello I have been testing the new row level security feature of 9.5 and I have some notes and questions on it. This is a simple table for the test, with 2 rows and a user named john, who is granted access to the table through a group named u

Re: [GENERAL] Row level security - notes and questions

2015-07-11 Thread Stephen Frost
Charles, * Charles Clavadetscher (clavadetsc...@swisspug.org) wrote: > I have been testing the new row level security feature of 9.5 and I have > some notes and questions on it. Great! Glad to hear it. > My first test is to enable row level security on the table without a policy > in place. Acc

[GENERAL] Row level security - notes and questions

2015-07-10 Thread Charles Clavadetscher
Hello I have been testing the new row level security feature of 9.5 and I have some notes and questions on it. This is a simple table for the test, with 2 rows and a user named john, who is granted access to the table through a group named users. CREATE TABLE testrls.accounts ( id integer,