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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
