Re: drop role with privileges

From: "Tom Darci" <tom(at)nuws(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: drop role with privileges
Date: 2006-12-11 15:27:53
Message-ID: A70D5EAEADAEB6438A262830763338A964AD77@MI8NYCMAIL16.Mi8.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>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 given roles on objects
in the current database will also be revoked.", which is right there.
I'll give that a spin (first using REASSIGN OWNED so that objects don't
get dropped). Thank you, Alvaro.

-Tom D

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-12-11 15:29:07 Re: TOAD-like query builder for PostgreSQL?
Previous Message Tom Darci 2006-12-11 15:24:00 Re: drop role with privileges