X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 90BA3529E7 for ; Thu, 18 Aug 2005 11:37:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18225-04 for ; Thu, 18 Aug 2005 14:37:37 +0000 (GMT) Received: from smtp105.rog.mail.re2.yahoo.com (smtp105.rog.mail.re2.yahoo.com [206.190.36.83]) by svr1.postgresql.org (Postfix) with SMTP id 25F915298D for ; Thu, 18 Aug 2005 11:37:35 -0300 (ADT) Received: (qmail 64777 invoked from network); 18 Aug 2005 14:37:39 -0000 Received: from unknown (HELO dahmer) (tgoodaire@24.156.104.98 with login) by smtp105.rog.mail.re2.yahoo.com with SMTP; 18 Aug 2005 14:37:39 -0000 Received: by dahmer (Postfix, from userid 1000) id 6F735EE9; Thu, 18 Aug 2005 10:37:17 -0400 (EDT) Date: Thu, 18 Aug 2005 10:37:16 -0400 To: Zuoxin.Wang@kp.org Cc: pgsql-admin@postgresql.org Subject: Re: GRANT ALL PRIVILEGES ON DATABASE Message-ID: <20050818143716.GB18290@dahmer> References: <1124294903.12095.141.camel@linda> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="24zk1gE8NUlDmwG9" Content-Disposition: inline In-Reply-To: <1124294903.12095.141.camel@linda> User-Agent: Mutt/1.5.10i From: tgoodaire@linux.ca (Tim Goodaire) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.077 required=5 tests=[AWL=0.077] X-Spam-Level: X-Archive-Number: 200508/236 X-Sequence-Number: 18555 --24zk1gE8NUlDmwG9 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable > On Wed, 2005-08-17 at 08:14 -0700, Zuoxin.Wang@kp.org wrote: > >=20 > > 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.=20 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=20 Tim --24zk1gE8NUlDmwG9 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFDBJ0cW1uYbjhxf+0RAkGHAJ9O2xAY4Mf81uZlk3qAfvFTiMP9XwCfTZ7F NZoSCV3OfbxsoBx58BG7zCI= =nZGo -----END PGP SIGNATURE----- --24zk1gE8NUlDmwG9--