Postgres Pro
Downloads
Home   >   mailing lists

How to remove a superuser - Mailing list pgsql-admin

From Richard Ray
Subject How to remove a superuser
Date
Msg-id Pine.LNX.4.64.0610101419170.12126@rray.drdc.mstc.ms.gov
Whole thread Raw
Responses Re: How to remove a superuser  ("Tomeh, Husam" <htomeh@firstam.com>)
Re: How to remove a superuser  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Alexander Burbello
Date:
Subject: Build an statement
Next
From: "Tomeh, Husam"
Date:
Subject: Re: How to remove a superuser