Hi All,
Manual: PostgreSQL 7.3 user manual
Section: 2.8.4
Should the revoke statement read:
REVOKE CREATE SCHEMA ON public FROM PUBLIC;
Instead of
REVOKE CREATE ON public FROM PUBLIC;
Without specifying SCHEMA (on my installation at least) the revoke command
complains about an "invalid privilege type CREATE for table object"
Best Regards,
Tim Knowles
_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/mobile