"Gonzales,S" <[EMAIL PROTECTED]> writes:
> How do i prevent ordinary users from altering the template1 database,
> eg they can create tables in template1;

Revoke public's CREATE rights on the public schema in template1.  See
the GRANT and REVOKE manual pages.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to