Re: Update row attribute that is part of row level security policy using_expression

2019-05-03 Thread Adrian Klaver
On 5/3/19 4:47 AM, Saupe Stefan wrote: I'd like to use RLS to 'hide' or 'deactivate' data at some point that some rows are not visible to the application user anymore. Let's say user a owns the data and can see all his data. The application user 'b' can only select,update,delete... 'active' da

Update row attribute that is part of row level security policy using_expression

2019-05-03 Thread Saupe Stefan
I'd like to use RLS to 'hide' or 'deactivate' data at some point that some rows are not visible to the application user anymore. Let's say user a owns the data and can see all his data. The application user 'b' can only select,update,delete... 'active' data, but is also able to 'deactivate' curre