On Aug 9, 2005, at 9:20 AM, Stephen Frost wrote:
* Marc G. Fournier (scrappy@xxxxxxxxxxxxxx) 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.
Also, there are some pl/pgsql functions available from here which
will GRANT/REVOKE on all tables:
http://pgedit.com/node/20
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
