Re: [GENERAL] Granting rights

2009-10-11 Thread Scott Marlowe
On Sun, Oct 11, 2009 at 11:05 AM, Otandeka Simon Peter wrote: > > 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? Rights don't work that way in pgsql. Each type of object has types of rights that m

[GENERAL] Granting rights

2009-10-11 Thread Otandeka Simon Peter
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 tim