can't revoke users - Mailing list pgsql-admin

From Scott Cotton
Subject can't revoke users
Date
Msg-id 2526be2b0802081601k64eb324dk8ac776659347ecde@mail.gmail.com
Whole thread Raw
Responses Re: can't revoke users  ("Peter Koczan" <pjkoczan@gmail.com>)
List pgsql-admin
I have a database that I dropped some users on. However, when doing dumps and restores, it became clear that these users were still being referenced by sysid. So I created new users and assigned them the sysids of the users I had dropped.

So now I went to revoke the privileges for the new (temp) users. However, some tables I can revoke the users and some I cannot.
I also tried to drop one of the new users I created and it created the same situation as before, where the user still shows up with priveleges, but instead of listing a name it lists a sysid.

Any ideas?

Thanks,
Scott

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Help calculating load values
Next
From: "dghundt@netzero.net"
Date:
Subject: pg_dump on windows