Thread: Revoke missing user

Revoke missing user

From
"Robert Fitzpatrick"
Date:
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?

--
Robert


Re: Revoke missing user

From
Tom Lane
Date:
"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