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.
