Re: GRANT ALL PRIVILEGES ON DATABASE - Mailing list pgsql-admin

From tgoodaire@linux.ca (Tim Goodaire)
Subject Re: GRANT ALL PRIVILEGES ON DATABASE
Date
Msg-id 20050818143716.GB18290@dahmer
Whole thread Raw
In response to Re: GRANT ALL PRIVILEGES ON DATABASE  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-admin
> On Wed, 2005-08-17 at 08:14 -0700, Zuoxin.Wang@kp.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.

You may be interested in the acl admin plpgsql scripts that Andrew
Hammond wrote to grant/revoke privileges: http://pgedit.com/public/sql/acl_admin/index.html

Tim

Attachment

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: GRANT ALL PRIVILEGES ON DATABASE
Next
From: "Dario"
Date:
Subject: Re: Server Won't Start On a Copy of Its Own Data Folder