Обсуждение: Setting owner for all tables
Hello all,
I'm using a template database as the base for new database creation. The user executing this command is a superuser. Here's the SQL statement that I'm using for creating new databases:
CREATE DATABASE mynewdatabase OWNER someuser TEMPLATE mytemplatedb ENCODING 'UTF8'.
I noticed that all the tables still seem to be owned by the user that created the template database initially which isn't what I expected. Is there a step that I'm missing that will allow me to have all the tables / functions / etc ownership changed also? I'm running postgresql-8.1.
Thanks!
I'm using a template database as the base for new database creation. The user executing this command is a superuser. Here's the SQL statement that I'm using for creating new databases:
CREATE DATABASE mynewdatabase OWNER someuser TEMPLATE mytemplatedb ENCODING 'UTF8'.
I noticed that all the tables still seem to be owned by the user that created the template database initially which isn't what I expected. Is there a step that I'm missing that will allow me to have all the tables / functions / etc ownership changed also? I'm running postgresql-8.1.
Thanks!
Hi,
If it is the super user, you need tot do an ALTER TABLE to change the owner.
Regards,
Serge Fonville
On Tue, Feb 10, 2009 at 3:18 PM, Chris McKinney <nowaydown1@gmail.com> wrote:
Hello all,
I'm using a template database as the base for new database creation. The user executing this command is a superuser. Here's the SQL statement that I'm using for creating new databases:
CREATE DATABASE mynewdatabase OWNER someuser TEMPLATE mytemplatedb ENCODING 'UTF8'.
I noticed that all the tables still seem to be owned by the user that created the template database initially which isn't what I expected. Is there a step that I'm missing that will allow me to have all the tables / functions / etc ownership changed also? I'm running postgresql-8.1.
Thanks!