[SQL] simulating row ownership

[Rick Schumeyer]

I have a table where I want everyone to be able to be able to insert and select. But they should only be able to update and delete rows that they “own”.  The table has a column indicating the owner.   What is the best way to accomplish this?  I’m not real familiar with rules, but it seems that I can do this with rules for update and delete applied to the table.  Someone had suggesting using views, but since I can’t update a view in postgres, I’m not sure that views help here.   I assume if I use rules, then I need to grant all to public, and let the rules prevent users from updating the wrong rows?   Any advice is appreciated.