Thread: re-REVOKE
The REVOKE did not function.
I have an user 27, when I execute commando below, the user does not lose the rights.
REVOKE ALL PRIVILEGES ON capitais FROM "27" ;
table capitais: ACL is {"=","27=arwR",martins=arwR"}
What I must make?
Regards.
"Robson Martins" <robson-martins@bol.com.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