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?
