Permission on insert rules

Поиск
Список
Период
Сортировка
От Luis Sousa
Тема Permission on insert rules
Дата
Msg-id 3DCBF47B.7080809@ualg.pt
обсуждение исходный текст
Ответы Re: Permission on insert rules  (Josh Berkus <josh@agliodbs.com>)
Re: Permission on insert rules  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
Hello everybody,

Just a question.
I'm writing some rules to insert/update some data in my database, and I 
gave all the privileges on that view to the user, and only select on the 
tables.
When that user inserts data using the view, I thought that was user 
postgres that will do the rest ! But I got  permission denied on those 
tables.
The idea was to create a layer, with the views, giving to that user 
permission on views to insert and update, and not to tables.
Is this possible ?

Thanks in advance.
Luis Sousa

В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_dump, no inserts but \copy?
Следующее
От: Roberto Mello
Дата:
Сообщение: Time difference without intervals