simulating row ownership
| От | Rick Schumeyer |
|---|---|
| Тема | simulating row ownership |
| Дата | |
| Msg-id | 001901c4f4d9$395726f0$0200a8c0@dell8200 обсуждение |
| Ответы |
Re: simulating row ownership
Re: simulating row ownership |
| Список | pgsql-sql |
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.
В списке pgsql-sql по дате отправления: