From: Alvaro Herrera <alvherre@commandprompt.com>
To: Marc Fromm <Marc.Fromm@wwu.edu>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: drop role fails
Date: Wed, 29 Oct 2008 12:51:44 -0300
Message-ID: <20081029155144.GB4331@alvh.no-ip.org> (raw)
In-Reply-To: <B0D7C0A3F35FE144A70312D086CBCA9B020CA60710@ExchMailbox2.univ.dir.wwu.edu>
References: <B0D7C0A3F35FE144A70312D086CBCA9B020CA60710@ExchMailbox2.univ.dir.wwu.edu>
Marc Fromm wrote:
> I need to drop a role/user but receive the message:
> ERROR: role "ken" cannot be dropped because some objects depend on it
> DETAIL: 1 objects in database css
> 1 objects in database manuals
> 1 objects in database cswe2
>
> I checked the databases listed and the user/role ken is not associated with any items in the database, owner is always listed as postgres.
Probably it has been granted permissions. Try DROP OWNED BY (which
should revoke the permissions), maybe preceded by REASSIGN OWNED BY just
to ensure you don't drop objects you wanted to keep ...
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, Marc.Fromm@wwu.edu
Subject: Re: drop role fails
In-Reply-To: <20081029155144.GB4331@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox