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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
