From: | "Igor Neyman" <ineyman(at)perceptron(dot)com> |
---|---|
To: | <rexmabry(at)yahoo(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: dropping a user in 8.2.6 |
Date: | 2008-07-08 17:16:16 |
Message-ID: | F4C27E77F7A33E4CA98C19A9DC6722A2032D88CC@EXCHANGE.corp.perceptron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
First do:
DROP OWNED BY user1;
then:
drop role user1;
Igor
________________________________
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Rex Mabry
Sent: Tuesday, July 08, 2008 12:45 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] dropping a user in 8.2.6
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Montaseri | 2008-07-08 18:12:12 | Re: Recommended RAID for Postgres |
Previous Message | kevin kempter | 2008-07-08 17:04:01 | Re: Dupes inserted that violate the PK |