changing ownership of db - Mailing list pgsql-novice

From Mark Nelson
Subject changing ownership of db
Date
Msg-id 01KXV1IGIYMA985WLI@cc.usu.edu
Whole thread Raw
Responses Re: changing ownership of db  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
One of our databases was created with a user that we no longer
want to use. I cannot drop the user because it owns one of the
dbs and some other objects.

Is there a way to change ownership, or REVOKE all of the owners
privileges and give them to another user, so I can drop that
user?

/mark


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: One more keywords problem (hopefully the last)
Next
From: "Daniel Phlander"
Date:
Subject: Mailing list