Granting rights

From: Otandeka Simon Peter <sotandeka(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Granting rights
Date: 2009-10-11 17:05:49
Message-ID: efc321cd0910111005o742206d9y26988ed7c50fa16b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is it possible to give a user rights(update,select,insert) rights on a
database and not necessary doing that for one relation at a time?

I have many tables in the database but I don't want this user to be able to
delete a relation. Granting the user rights per table is gonna
take a lot of time.

Any better way to do it without me having to write a script?

Cheers,
P.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Naoko Reeves 2009-10-11 17:51:49 Is there a way to know if trigger is invoked by the code from another trigger
Previous Message Jignesh Shah 2009-10-11 16:00:42 Re: What is statement ID of table?