From: | sam(at)edup(dot)tudelft(dot)nl (Sam) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | create template database |
Date: | 2004-01-06 13:02:07 |
Message-ID: | ff8cfc7.0401060502.67e68517@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to create a template database as a superuser. I set the
value in pg_database datistemplate to 't'. But when I create a
database as another user i don't have any priviliges on the tables in
the new database. So I granted ALL to PUBLIC on the tables in the
template database. Now when I create a database with the new template
I can use it, but the tables are still owned by the user that created
(owns) the template.
Is there anything i need to do to make the template a true template, I
mean, that it behaves in the same way as template1?
GreetZ, Sam
ps: A happy new year to you all!
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2004-01-06 13:30:04 | Re: Any way to have CREATEUSER privs without having all privs? |
Previous Message | Peter Eisentraut | 2004-01-06 11:58:28 | Re: pg_dump and client_encoding |