Re: re-REVOKE

"Robson Martins" <robson-martins(at)bol(dot)com(dot)br> writes:
> I have an user 27, when I execute commando below, the user does not lose th=
> e rights.=20
> REVOKE ALL PRIVILEGES ON capitais FROM "27" ;
> table capitais: ACL is {"=3D","27=3DarwR",martins=3DarwR"}

Do you actually have a user named "27"?

I'm thinking this is an instance of a privilege for a user who used
to have sysid 27 but has been removed. The privilege entry is still
there, but is listed with the numeric sysid because the system cannot
find a name to display for it.

You can ignore the privilege item since it's nonfunctional (can't
ever be used). Or you can create a user with sysid 27 (read the
CREATE USER man page), then REVOKE using that username, and
finally drop the user again.

regards, tom lane