From: tgoodaire@linux.ca
To: Zuoxin.Wang@kp.org
Cc: pgsql-admin@postgresql.org
Subject: Re: GRANT ALL PRIVILEGES ON DATABASE
Date: Thu, 18 Aug 2005 10:37:16 -0400
Message-ID: <20050818143716.GB18290@dahmer> (raw)
In-Reply-To: <1124294903.12095.141.camel@linda>
References: <OFF2C30C25.B80FFBF2-ON88257060.00535B8D@KP.ORG>
<1124294903.12095.141.camel@linda>
> 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
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgoodaire@linux.ca, Zuoxin.Wang@kp.org
Subject: Re: GRANT ALL PRIVILEGES ON DATABASE
In-Reply-To: <20050818143716.GB18290@dahmer>
References: <OFF2C30C25.B80FFBF2-ON88257060.00535B8D@KP.ORG> <1124294903.12095.141.camel@linda> <20050818143716.GB18290@dahmer>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox