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?
