Re: GRANT ALL PRIVILEGES ON DATABASE

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Zuoxin(dot)Wang(at)kp(dot)org
Cc: olly(at)lfix(dot)co(dot)uk, agold(at)cbamedia(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: GRANT ALL PRIVILEGES ON DATABASE
Date: 2005-08-17 15:54:55
Message-ID: 20050817155455.GA28113@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Aug 17, 2005 at 08:14:02 -0700,
Zuoxin(dot)Wang(at)kp(dot)org wrote:
> Could you tell us what is the best way to grant a user who can select all
> data from all tables, if I don't like to write a script which Andrew
> memtioned earlier.

Other than some kind of script, you can make them a superuser. That may not
work for you though.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2005-08-17 15:57:53 Re: vacuumdb -a -f
Previous Message Andrew Gold 2005-08-17 15:35:06 Re: GRANT ALL PRIVILEGES ON DATABASE