Skip site navigation (1) Skip section navigation (2)

Re: Creating tables...not a usual question (I think)

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Rodrigo Sakai <rodrigo(dot)sakai(at)poli(dot)usp(dot)br>
Subject: Re: Creating tables...not a usual question (I think)
Date: 2005-08-23 12:23:25
Message-ID: 430B153D.5010605@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-admin
Rodrigo Sakai wrote:
>   Hi all, I have a question!
>   Suppose that you have a 'virtualstore' database that are owned by
> Peter, the enterprise DBA. So why the tables that we create inside
> 'virtualstore' don't have peter as owner automatically??? I mean, why
> don't the tables inherits the owner of the database???
>  

Why it should? If an user have permission to create table why the tables
created shall be owned by another user ?
It's like you create a file in your filesystem and the owner is someone else.


Regards
Gaetano Mendola

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-08-23 14:20:00
Subject: Re: encoding issue with postgres 8.0
Previous:From: Kailash VyasDate: 2005-08-23 11:54:51
Subject: encoding issue with postgres 8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group