pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gonzales,S <gonzales_speedy@fastmail.fm>
To: pgsql-admin@postgresql.org
Subject: securing template1
Date: Mon, 27 Sep 2004 16:50:42 +0200
Message-ID: <cj99c3$tef$1@ikaria.belnet.be> (raw)

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,



view thread (2+ messages)  latest in thread

Message-ID: <cj99c3$tef$1@ikaria.belnet.be>
Permalink:  ../cj99c3$tef$1@ikaria.belnet.be/
Also on:    postgresql.org/message-id/cj99c3$tef$1@ikaria.belnet.be

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gonzales_speedy@fastmail.fm
  Subject: Re: securing template1
  In-Reply-To: <cj99c3$tef$1@ikaria.belnet.be>
  References: <cj99c3$tef$1@ikaria.belnet.be>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox