Hi guys, I’m seeing some non-intuitive behavior with the new updateable
security barrier views in 9.4. Below is the behavior of 9.4b3:
> =# create table widget ( id integer);
> CREATE TABLE
> =# create view widget_sb WITH (security_barrier=true) AS SELECT * from widget
> where id = 22;
> CREATE
Hello list,
I am posting here since Craig Ringer suggested user feedback on this feature at
this time may make a difference for 9.4 inclusion. I apologize if I am in the
wrong place.
Row-level security is probably THE major element the FOSS databases are behind
compared to proprietary databas