changing ownership of db

From: Mark Nelson <MCN(at)cc(dot)usu(dot)edu>
To: PGSQL-NOVICE(at)POSTGRESQL(dot)ORG
Subject: changing ownership of db
Date: 2003-07-04 19:12:20
Message-ID: 01KXV1IGIYMA985WLI@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel Phlander 2003-07-04 19:28:36 Mailing list
Previous Message Tom Lane 2003-07-04 13:40:24 Re: One more keywords problem (hopefully the last)