Thread: Grant group revoke user isue

Hallo,

version 7.4.7

i first grant a group some privileges,
then i take those privileges away from a user in this group,
somehow this doens't work (no errors, but the rights aren't revoked)

eg:

GRANT ALL ON TABLE test TO GROUP groep;
--the user jimmy is part of groep;
REVOKE ALL ON TABLE test FROM jimmy;
--no complaint, but also nothing is revoked

suggestion, explanations?

tnx,

On Nov 22, 2006, at 12:19 PM, Wim Bertels wrote:
> version 7.4.7
>
> i first grant a group some privileges,
> then i take those privileges away from a user in this group,
> somehow this doens't work (no errors, but the rights aren't revoked)
>
> eg:
>
> GRANT ALL ON TABLE test TO GROUP groep;
> --the user jimmy is part of groep;
> REVOKE ALL ON TABLE test FROM jimmy;
> --no complaint, but also nothing is revoked

It's been a long time since I worked with 7.4, but IIRC this is an
issue of the REVOKE not taking effect until sessions disconnect. You
can probably find more info in the archives.
--
Jim Nasby                               jim.nasby@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)