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?
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 |