Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Grant group revoke user isue
- From: "Jim Nasby" <jim(dot)nasby(at)enterprisedb(dot)com>
- To: "Wim Bertels" <wim(dot)bertels(at)khleuven(dot)be>
- Cc: <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Grant group revoke user isue
- Date: Fri, 24 Nov 2006 14:18:10 -0600
- Message-id: <4A17C2E6-FE61-4F9E-A749-A3F0AE266EA3(at)enterprisedb(dot)com>
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(dot)nasby(at)enterprisedb(dot)com EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
- References:
- Grant group revoke user isue
- From: Wim Bertels
- Grant group revoke user isue
- Prev by Date: Re: Druid for postgreSQL - can I export my ERD to MS Access?
- Next by Date: Re: advanced index (descending and table-presorted descending)
- Previous by thread: Grant group revoke user isue
- Next by thread: Re: BUG #2772: Undefined Subroutine Pg::connectdb (" ");
- Indexes: