Thread: re-REVOKE

re-REVOKE

From
"Robson Martins"
Date:
  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.

Re: re-REVOKE

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