* Marc G. Fournier ([EMAIL PROTECTED]) 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

Attachment: signature.asc
Description: Digital signature

Reply via email to