* 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. Stephen
Attachment:
signature.asc
Description: Digital signature
