From: | "Gonzales,S" <gonzales_speedy(at)fastmail(dot)fm> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | securing template1 |
Date: | 2004-09-27 14:50:42 |
Message-ID: | cj99c3$tef$1@ikaria.belnet.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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,
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Kiger | 2004-09-27 16:32:30 | Re: tsearch2 poor performance |
Previous Message | Christian Fowler | 2004-09-27 14:43:54 | short lines in big dump prevent backup |