Re: Revoking CREATE TABLE

On Wednesday 24 March 2010 17.28:37 Tony Webb wrote:
> #revoke create on schema public from public;
> REVOKE

Note that this will *only* revoke the create right from "PUBLIC" and not
from any individual role that may have the right. PostgreSQL unfortunately
does not have a "revoke ... from ALL".

So you need to revoke from all individual roles that have the right on this
database/schema.

cheers
-- vbi

--
Vorteil kleiner Menschen: Sie werden bei Regen später naß.