Re: How to remove a superuser

From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: "Richard Ray" <rray(at)mstc(dot)state(dot)ms(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: How to remove a superuser
Date: 2006-10-10 20:39:55
Message-ID: CB0FB369FF86E248A884BCC002562BCB0227DABB@pisgsna01sxch01.ana.firstamdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


My understanding is that, in 8.1, you'd need to revoke the privileges
before being able to drop the role/user.

8.2 seems to have two additional nice commands: "drop owned" command to
remove the objects owned by the user, and "reassign owned" to change the
ownership and give the objects to someone else.

http://developer.postgresql.org/pgdocs/postgres/sql-drop-owned.html
http://developer.postgresql.org/pgdocs/postgres/sql-reassign-owned.html

--
Husam
http://firstdba.googlepages.com

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Richard Ray
Sent: Tuesday, October 10, 2006 12:23 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] How to remove a superuser

I need to drop a superuser account. I get

dba=# drop role bram;
ERROR: role "bram" cannot be dropped because some objects depend on it
DETAIL: owner of view teacher
owner of type teacher
owner of view temp1
owner of type temp1
...

What is the preferred method.

Thanks
Richard Ray

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged. If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

FADLD Tag
**********************************************************************

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-10 20:41:23 Re: How to remove a superuser
Previous Message Richard Ray 2006-10-10 19:22:53 How to remove a superuser