Alter privileges for all tables

Hi Sean,

On Aug 1, 2005, at 8:40 AM, Sean Davis wrote:

Sorry to ask this again, but I seem to have misplaced the original
discussion and can't find it in the archives--could someone point
me to the
thread on functions to batch alter privileges on all tables (or a
subset) in
a database?

You can find some functions for this here:

http://pgedit.com/node/20

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

Sean Davis wrote:

Sorry to ask this again, but I seem to have misplaced the original
discussion and can't find it in the archives--could someone point me to the
thread on functions to batch alter privileges on all tables (or a subset) in
a database?

On a somewhat related note, is revoking all on a schema sufficient to
prevent users (or, say, group public) from accessing anything w/i that
schema, or do I need to explicitly set rights on all of the objects w/i
the schema?

--
Peter Fein pfein@pobox.com 773-575-0694

Basically, if you're not a utopianist, you're a schmuck. -J. Feldman