Re: [SQL] Do update permissions require select permissions

2003-11-28 Thread Tom Lane
[EMAIL PROTECTED] (Chris Piker) writes: > Now as some other user one can do: >update data set stuff = 'other stuff'; > And it works okay. But the following fails: >update data set stuff = 'yet other stuff' where id = 1; > Why is this? Because the latter requires reading, not only writin

[SQL] Do update permissions require select permissions

2003-11-28 Thread Chris Piker
I have run across a problem while creating a database with row level permission checking via views and triggers. The just of which is update does not work for a user unless they also have select permissions. Select permissions are handled with a view, while insert, update and delete permissions a