Re: securing template1

"Gonzales,S" <gonzales_speedy@fastmail.fm> 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