Thread: Setting owner for all tables

Setting owner for all tables

From
Chris McKinney
Date:
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!


Re: Setting owner for all tables

From
Serge Fonville
Date:
Hi,

The user creating the tables, is that the owner of the database or the super user?'
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!