X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7A55952A46; Tue, 9 Aug 2005 10:20:04 -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 03490-03; Tue, 9 Aug 2005 13:19:59 +0000 (GMT) Received: from ns.snowman.net (ns.snowman.net [66.92.160.21]) by svr1.postgresql.org (Postfix) with ESMTP id 77ED0529C4; Tue, 9 Aug 2005 10:19:55 -0300 (ADT) Received: by ns.snowman.net (Postfix, from userid 1000) id A84DD17AD3; Tue, 9 Aug 2005 09:20:15 -0400 (EDT) Date: Tue, 9 Aug 2005 09:20:15 -0400 From: Stephen Frost To: "Marc G. Fournier" Cc: pgsql-admin@postgresql.org Subject: Re: REVOKE from all tables ... Message-ID: <20050809132015.GW6026@ns.snowman.net> Mail-Followup-To: "Marc G. Fournier" , pgsql-admin@postgresql.org References: <20050809004545.S958@hub.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Evp0T6PXIQ26qRMT" Content-Disposition: inline In-Reply-To: <20050809004545.S958@hub.org> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 09:17:41 up 59 days, 5:35, 6 users, load average: 0.17, 0.13, 0.09 User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/103 X-Sequence-Number: 18422 --Evp0T6PXIQ26qRMT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Marc G. Fournier (scrappy@postgresql.org) wrote: > Is there a way of REVOKEing privileges on all tables in a database? I've= =20 > checked the REVOKE man page, and there doesn't appear to be, but I figure= d=20 > I'd double check to make sure ... I actually wrote a little perl script which allows you to pass in a regexp to match names against, allows for limitation to a specific schema, and handles tables, views, sequences and functions. I'll see about making it available (it's not very big). Of course, I think it'd be nice to have some functions in core that did the same thing; or maybe some ability in psql to do it. Stephen --Evp0T6PXIQ26qRMT 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) iD8DBQFC+K2OrzgMPqB3kigRAqayAJ9o/fSLEbDWTPD7LXaAkuhkUpaF1ACeKIAf jLhZ8F+CScCkRQtBDg3mucc= =WoOm -----END PGP SIGNATURE----- --Evp0T6PXIQ26qRMT--