How to add permissions to views?

Поиск
Список
Период
Сортировка
От Andre Lopes
Тема How to add permissions to views?
Дата
Msg-id AANLkTik7ax7NH8VpQj8+G0norqJkgQbKUOQvqkFhzY+G@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Hi,

I have developed a database system where every table have a view mapping the contents, so the users don't have direct access to the tables. For UPDATE and DELETE I have created RULES on the views.

My question:

I will create a user to give permissions to the views. I don't know what kind of permissions I should add. For example, for a view that have RULEs for UPDATE and DELETE wich kind of GRANT should I do?


PS: Sorry for my bad english.

Best Regards,

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

Предыдущее
От: "Carlo Stonebanks"
Дата:
Сообщение: Re: Very bad plan when using VIEW and IN (SELECT...*)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Very bad plan when using VIEW and IN (SELECT...*)