How to add permissions to views?

From: Andre Lopes <lopes80andre(at)gmail(dot)com>
To: postgresql Forums <pgsql-general(at)postgresql(dot)org>
Subject: How to add permissions to views?
Date: 2010-08-13 14:55:15
Message-ID: AANLkTik7ax7NH8VpQj8+G0norqJkgQbKUOQvqkFhzY+G@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-08-13 15:03:37 Re: Very bad plan when using VIEW and IN (SELECT...*)
Previous Message Carlo Stonebanks 2010-08-13 14:52:27 Re: Very bad plan when using VIEW and IN (SELECT...*)