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

Attachment: signature.asc
Description: This is a digitally signed message part.

Reply via email to