Re: GRANT ALL PRIVILEGES ON DATABASE

From: tgoodaire(at)linux(dot)ca (Tim Goodaire)
To: Zuoxin(dot)Wang(at)kp(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: GRANT ALL PRIVILEGES ON DATABASE
Date: 2005-08-18 14:37:16
Message-ID: 20050818143716.GB18290@dahmer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Wed, 2005-08-17 at 08:14 -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.

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Dario 2005-08-18 15:45:58 Re: Server Won't Start On a Copy of Its Own Data Folder
Previous Message Aldor 2005-08-18 13:08:14 Normal VACUUM locks indexes?