Re: REVOKE ... FROM everybody?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: REVOKE ... FROM everybody?
Date: 2010-03-12 15:03:43
Message-ID: 20100312150343.GA3663@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian von Bidder wrote:
> Heyho!
>
> As far as I understand, REVOKE .. FROM PUBLIC revokes rights that were given
> to everybody. Is there a way to revoke rights given to *any*body? (all
> users)? Or do I misunderstand PUBLIC?

You're misunderstanding -- if you revoke from public, only the grant
given to public is revoked. Grants to other roles are kept. To revoke
all grants, you need to list them individually IIRC.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2010-03-12 15:04:52 Re: Postgres GIS Question
Previous Message jody 2010-03-12 15:00:54 beginning and ending of sessions