X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7C108D6F61 for ; Tue, 23 Aug 2005 09:30:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33815-08 for ; Tue, 23 Aug 2005 12:30:52 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 88AB6D6F01 for ; Tue, 23 Aug 2005 09:30:52 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j7NCUmAw093089 for ; Tue, 23 Aug 2005 12:30:48 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j7NCNO6Y071398 for pgsql-admin@postgresql.org; Tue, 23 Aug 2005 12:23:24 GMT (envelope-from news) From: Gaetano Mendola X-Newsgroups: pgsql.admin Subject: Re: Creating tables...not a usual question (I think) Date: Tue, 23 Aug 2005 14:23:25 +0200 Organization: Hub.Org Networking Services Lines: 15 Message-ID: <430B153D.5010605@bigfoot.com> References: <001201c5a7b4$ec23d3d0$0201a8c0@netsis01xp> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Rodrigo Sakai User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <001201c5a7b4$ec23d3d0$0201a8c0@netsis01xp> X-Enigmail-Version: 0.90.1.1 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=-2.578 required=5 tests=[ALL_TRUSTED=-2.82, AWL=0.242] X-Spam-Level: X-Archive-Number: 200508/280 X-Sequence-Number: 18599 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