Re: REVOKE from all tables ...

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.