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 7B6CD52AE7 for ; Tue, 9 Aug 2005 11:09:58 -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 93719-03 for ; Tue, 9 Aug 2005 14:09:53 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.199]) by svr1.postgresql.org (Postfix) with ESMTP id BC00752AFF for ; Tue, 9 Aug 2005 11:09:51 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id c2so283230nfe for ; Tue, 09 Aug 2005 07:09:54 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=Y4TvDYPwufHW8sdFrqY6AK7saHzknJwZka5jmiQisk5VXnQZqe7+gfHexR/O0CZfuekZ8zdFJzYB6Jyme4X+3oR4pgR0E6fLysZOMWhqjQr8O7GM3HaC0TXHrZenY+bRxXra8ThxT3h7MQFZ1qPGU62E4KQDVkYf5VJQAKgxmC0= Received: by 10.48.143.9 with SMTP id q9mr201484nfd; Tue, 09 Aug 2005 07:09:53 -0700 (PDT) Received: by 10.48.144.16 with HTTP; Tue, 9 Aug 2005 07:09:53 -0700 (PDT) Message-ID: Date: Tue, 9 Aug 2005 15:09:53 +0100 From: Guido Barosio To: "Marc G. Fournier" , pgsql-admin@postgresql.org Subject: Re: REVOKE from all tables ... In-Reply-To: <20050809132015.GW6026@ns.snowman.net> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8891_27612245.1123596593965" References: <20050809004545.S958@hub.org> <20050809132015.GW6026@ns.snowman.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.174 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200508/106 X-Sequence-Number: 18425 ------=_Part_8891_27612245.1123596593965 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline It would be great to look at that :) g On 8/9/05, Stephen Frost wrote:=20 >=20 > * Marc G. Fournier (scrappy@postgresql.org) wrote: > > Is there a way of REVOKEing privileges on all tables in a database? I'v= e > > checked the REVOKE man page, and there doesn't appear to be, but I=20 > figured > > I'd double check to make sure ... >=20 > 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. >=20 > Stephen >=20 >=20 > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (GNU/Linux) >=20 > iD8DBQFC+K2OrzgMPqB3kigRAqayAJ9o/fSLEbDWTPD7LXaAkuhkUpaF1ACeKIAf > jLhZ8F+CScCkRQtBDg3mucc=3D > =3DWoOm > -----END PGP SIGNATURE----- >=20 >=20 >=20 --=20 "Adopting the position that you are smarter than an automatic optimization algorithm is generally a good way to achieve less performance, not more" - Tom Lane. ------=_Part_8891_27612245.1123596593965 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
It would be great to look at that :)
 
 
g

 
On 8/9/05, S= tephen Frost <sfrost@snowman.n= et> wrote:
* Marc G. Fournier (scrappy@postgresql.org) wrote:
> Is= there a way of REVOKEing privileges on all tables in a database? &nbs= p;I've
> checked the REVOKE man page, and there doesn't appear to be, but I= figured
> 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 co= urse, I think it'd
be nice to have some functions in core that did the s= ame thing; or maybe
some ability in psql to do it.

     &nb= sp; Stephen


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4= .1 (GNU/Linux)

iD8DBQFC+K2OrzgMPqB3kigRAqayAJ9o/fSLEbDWTPD7LXaAkuhkU= paF1ACeKIAf
jLhZ8F+CScCkRQtBDg3mucc=3D
=3DWoOm
-----END PGP SIGNATURE-----




--
"Adopting the position that you are sma= rter than an automatic
optimization algorithm is generally a good way to= achieve less
performance, not more" - Tom Lane.=20 ------=_Part_8891_27612245.1123596593965--