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ß.