removing a user who owns objects

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: removing a user who owns objects
Date: 2002-06-12 22:03:29
Message-ID: Pine.LNX.4.44.0206121502230.11061-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


What am I missing?

I want to remove a user who owns databases and objects.

I can change the owner of a database by updating the datdba field in
pg_database.

This allows me to drop the user!

However, the user still owns other objects. So, I have found that I also
need to fix ownership for:
pg_aggregate - aggowner
pg_class - relowner
pg_operator - oprowner
pg_proc - proowner
pg_type - typowner
in each database.

YET, I still have problems as my java program fails with an error:
"pg_aclcheck: invalid user id 111"

Is there something else I am missing?

Thanks for the help,

--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Where's my....bus?

Browse pgsql-admin by date

  From Date Subject
Next Message Michael G. Martin 2002-06-12 22:21:12 UnUsed Tuple Space Huge
Previous Message Chris Gamache 2002-06-11 21:27:52 Re: "ERROR:" Messages