Re: Revoke missing user

"Robert Fitzpatrick" <robert@webtent.com> writes:
> I removed a user from PostgreSQL that had privileges on some tables, now
> the access privileges shows just the former user number. When I try:
>   revoke all on allergies from 104;
> I get:
>   ERROR:  parser: parse error at or near "104" at character 30
> I even try creating a user named 104, same result. How can I revoke
> those privileges?

Create a user with the old user number:

    create user revenant with sysid 104;

and now you can do the revokes using that username.

            regards, tom lane