| 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: | Whole Thread | Raw Message | 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 |