X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 92198329EB8 for ; Mon, 27 Sep 2004 16:15:44 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09639-10 for ; Mon, 27 Sep 2004 15:15:39 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id ED3CA329EE1 for ; Mon, 27 Sep 2004 16:15:39 +0100 (BST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i8RFFbfg016483 for ; Mon, 27 Sep 2004 15:15:37 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i8REocm0006047 for pgsql-admin@postgresql.org; Mon, 27 Sep 2004 14:50:38 GMT From: "Gonzales,S" X-Newsgroups: comp.databases.postgresql.admin Subject: securing template1 Date: Mon, 27 Sep 2004 16:50:42 +0200 Organization: BELNET - The Belgian Research Network Lines: 27 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@belnet.be User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; nl-NL; rv:1.7.3) Gecko/20040910 X-Accept-Language: nl-be, nl, en-us, en To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/5 X-Sequence-Number: 14999 How do i prevent ordinary users from altering the template1 database, eg they can create tables in template1; revoke doenst do the trick, template1 remains visible and a user can create table in template1 using for example pgadmin select * from pg_database where datname like '%temp%'; datname | datdba | encoding | datistemplate | datallowconn | datlastsysoid | datvacuumxid | datfrozenxid | datpath | datconfig | datacl ---------------+--------+----------+---------------+--------------+---------------+--------------+--------------+---------+-----------+-------------------------- template1 | 1 | 6 | t | t | 17140 | 4628963 | 3225854436 | | | {postgres=C*T*/postgres} template0 | 1 | 0 | t | f | 17140 | 464 | 464 | | | {postgres=C*T*/postgres} ouwetemplate1 | 1 | 0 | t | t | 17140 | 4623413 | 3225848886 | | | {postgres=C*T*/postgres} (3 rows) tnx,