"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
