Skip site navigation (1) Skip section navigation (2)

Re: Removing Users and Revoking Privileges

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Carl McCalla <Carl(dot)Mccalla(at)noaa(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org, Steve R Olson <Steve(dot)R(dot)Olson(at)noaa(dot)gov>
Subject: Re: Removing Users and Revoking Privileges
Date: 2008-02-29 20:26:18
Message-ID: 20080229202618.GC28668@svana.org (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, Feb 29, 2008 at 01:12:50PM -0500, Carl McCalla wrote:
> What I have been unable to do successfully is to remove two users who 
> should no longer have access to the database or its tables.  As super 
> user postgres, I have attempted to REVOKE access privileges for those 
> two users, but to no avail.  The REVOKE command appears to work and does 
> not generate an error message, however, upon inspection the two users 
> remain and continue to have all of the same access privileges they had 
> before executing the REVOKE command.

Something that some people trip over is that there's still access for
PUBLIC or access via a role. Perhaps you could show the \z output for
the table in question...

Hope this helps,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

In response to

pgsql-general by date

Next:From: Mike GouldDate: 2008-02-29 20:28:11
Subject: SERIAL and Primary Key
Previous:From: brianDate: 2008-02-29 19:48:49
Subject: Re: issue with an assembled date field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group