Postgres Pro
Downloads
Home   >   mailing lists

dropping a user in 8.2.6 - Mailing list pgsql-admin

From Rex Mabry
Subject dropping a user in 8.2.6
Date
Msg-id 956278.50750.qm@web35906.mail.mud.yahoo.com
Whole thread Raw
Responses Re: dropping a user in 8.2.6  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-admin
Tree view

I am using version 8.2.6

 

I created a role and granted all on table "instrument" in the database.  But, when I tried to drop the role, I get the following error:

 

mydb=# drop role system_dba;
ERROR:  role "user1" cannot be dropped because some objects depend on it
DETAIL:  access to table mydb_admin.instrument

Is there a way to drop a role with some sort of "cascade" option?


pgsql-admin by date:

Previous
From: kevin kempter
Date:
Subject: Dupes inserted that violate the PK
Next
From: Alvaro Herrera
Date:
Subject: Re: Dupes inserted that violate the PK