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

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

From
"Rodrigo Sakai"
Date:
  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???
 
  Thanks!

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

From
Gaetano Mendola
Date:
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