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.