mark.taber

Thanks! Worked like a charm.


Mark Taber
State of California
Department of Finance
Infrastructure & Architecture

916.323.3104 x 2945
mark.taber@dof.ca.gov

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, November 19, 2004 7:42 AM
To: Taber, Mark
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Phantom user in db--'128'

"Taber, Mark" <Mark.Taber@dof.ca.gov> writes:

You had a user with usesysid 128, whom you dropped, but he still had
privileges on some tables --- DROP USER is not good about detecting dangling
references.

I'd suggest recreating the user (CREATE USER foo WITH SYSID 128) and then
being careful to REVOKE all his privileges before you drop him again. Or
you can just manually edit the dump file to remove the attempts to GRANT him
privileges.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend