pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
drop role fails
2+ messages / 2 participants
[nested] [flat]

* drop role fails
@ 2008-10-29 15:40  Marc Fromm <Marc.Fromm@wwu.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Marc Fromm @ 2008-10-29 15:40 UTC (permalink / raw)
  To: pgsql-admin

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.


Marc

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: drop role fails
@ 2008-10-29 15:51  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Marc Fromm <Marc.Fromm@wwu.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Alvaro Herrera @ 2008-10-29 15:51 UTC (permalink / raw)
  To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-10-29 15:51 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-10-29 15:40 drop role fails Marc Fromm <Marc.Fromm@wwu.edu>
2008-10-29 15:51 ` Alvaro Herrera <alvherre@commandprompt.com>

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