Обсуждение: How to add permissions to views?

Поиск
Список
Период
Сортировка

How to add permissions to views?

От
Andre Lopes
Дата:
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,