Re: [GENERAL] [9.5] question about row level security

2015-07-15 Thread Charles Clavadetscher
| boss | boss | 10 | boss changed Hope this helps. Bye Charles > -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Andreas Kretschmer > Sent: Mittwoch, 15. Juli 2015 09:55 > To: pgsql-genera

[GENERAL] [9.5] question about row level security

2015-07-15 Thread Andreas Kretschmer
Hello @ll, how can i define a policy to prevent update a single field but enable update other fields in a row? For instance, a staff member table. the boss should be able to change all fields but not a specific field in all rows, but should be able to update this field for his own row. id | name