Change database ownership

If you are logged in as the admin user or the owner of a database, you can change the owner by using the ALTER DATABASE command.

The new owner must be a current user on the system. For example:

MYDB.SCHEMA(USER)=> ALTER DATABASE mydb OWNER TO jane;
ALTER DATABASE