>Did you try DROP OWNED BY? It revokes privileges (as well as
>dropping objects owned by said role).
Thank you. That was exactly the *easy* soluton I'd been missing. I swear
I read the page in the manual for "DROP OWNED" several times, hoping to
see something like "Any privileges granted to the
>>
>> That sounds very promising. I'll take a look there.
>
>I may be wrong about the table name but certainly drop role uses some
>set of system tables to do it's work. :)
THANKS for your help, Stephen. Once I've reassigned ownership
I can then easily find out privilege dependencies using
pg_
* Tom Darci ([EMAIL PROTECTED]) wrote:
> I've been looking into using the function aclcontains() in conjunction
> with the table pg_class, in order to determine which objects a role has
> been granted privilges to. And while this seems promising, I'm still not
> having any luck formulating the sq
Hey All-
It seems like there should be an easily-found answer to this, but if
there is, I can't find it.
I am simply trying to drop a role.
So, before dropping it I need to reassign all its owned objects
(REASSIGN OWNED, very handy) and then revoke all privilges it has had
assigned to it.
