Re: dangling permission on tables after drop user.
Andrew Sullivan <ajs@crankycanuck.ca>
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-general@postgresql.org
Date: 2004-10-06T18:01:54Z
Lists: pgsql-general
On Thu, Sep 30, 2004 at 10:03:29AM -0400, Alvaro Herrera wrote: > > I'm afraid you'll have to ALTER TABLE (or whatever) for each of these ... > I don't think there is a command that would help you do that > automatically. You can cheat by looking at system catalogs for the > acl column (e.g. pg_class.relacl) and using that in a function. Andrew Hammond is about to (has?) post some helper code he has for managing ACLs more easily. A -- Andrew Sullivan | ajs@crankycanuck.ca I remember when computers were frustrating because they *did* exactly what you told them to. That actually seems sort of quaint now. --J.D. Baldwin