Postgres Pro
Downloads
Home   >   mailing lists

Re: dropping a user in 8.2.6 - Mailing list pgsql-admin

From Igor Neyman
Subject Re: dropping a user in 8.2.6
Date
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A2032D88CC@EXCHANGE.corp.perceptron.com
Whole thread Raw
In response to dropping a user in 8.2.6  (Rex Mabry <rexmabry@yahoo.com>)
List pgsql-admin
Tree view
First do:
 
DROP OWNED BY user1;
then:
drop role user1;
 
Igor

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rex Mabry
Sent: Tuesday, July 08, 2008 12:45 PM
To: pgsql-admin@postgresql.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?


pgsql-admin by date:

Previous
From: kevin kempter
Date:
Subject: Re: Dupes inserted that violate the PK
Next
From: Montaseri
Date:
Subject: Re: Recommended RAID for Postgres