Re: dangling permission on tables after drop user.

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: dangling permission on tables after drop user.
Date: 2004-10-06 18:01:54
Message-ID: 20041006180154.GE29777@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)crankycanuck(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-10-06 18:23:48 Re: database constraints
Previous Message Bruno Wolff III 2004-10-06 17:48:16 Re: database constraints