Re: REVOKE from all tables ...

From: Guido Barosio <gbarosio(at)gmail(dot)com>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: REVOKE from all tables ...
Date: 2005-08-09 14:09:53
Message-ID: f7f6b4c705080907093023b302@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

It would be great to look at that :)
g

On 8/9/05, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
>
> * Marc G. Fournier (scrappy(at)postgresql(dot)org) wrote:
> > Is there a way of REVOKEing privileges on all tables in a database? 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 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
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (GNU/Linux)
>
> iD8DBQFC+K2OrzgMPqB3kigRAqayAJ9o/fSLEbDWTPD7LXaAkuhkUpaF1ACeKIAf
> jLhZ8F+CScCkRQtBDg3mucc=
> =WoOm
> -----END PGP SIGNATURE-----
>
>
>

--
"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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ben Kim 2005-08-09 14:13:55 Re: SQL Server 2000 to PostgreSQL 8.0.3
Previous Message Goulet, Dick 2005-08-09 13:50:17 Re: SQL Server 2000 to PostgreSQL 8.0.3