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? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
