Grant group revoke user isue

From: Wim Bertels <wim(dot)bertels(at)khleuven(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: Grant group revoke user isue
Date: 2006-11-22 18:19:02
Message-ID: 45649496.8090700@khleuven.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2006-11-22 18:27:10 Re: MSSQL to PostgreSQL : Encoding problem
Previous Message Jason Earl 2006-11-22 18:13:42 Re: PGSQL Newbie