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 по дате отправления: