Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id BEE8C9FB378 for ; Mon, 16 Apr 2007 18:54:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 31456-10 for ; Mon, 16 Apr 2007 18:54:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc2-s39.bay0.hotmail.com (bay0-omc2-s39.bay0.hotmail.com [65.54.246.175]) by postgresql.org (Postfix) with ESMTP id 713619FB2CB for ; Mon, 16 Apr 2007 18:54:43 -0300 (ADT) Received: from hotmail.com ([65.55.130.100]) by bay0-omc2-s39.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 16 Apr 2007 14:54:41 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 16 Apr 2007 14:54:41 -0700 Message-ID: Received: from 65.55.130.123 by by125fd.bay125.hotmail.msn.com with HTTP; Mon, 16 Apr 2007 21:54:40 GMT X-Originating-IP: [201.14.217.37] X-Originating-Email: [diego_de_lima@hotmail.com] X-Sender: diego_de_lima@hotmail.com From: "Diego de Lima" To: pgsql-admin@postgresql.org Subject: Hiding databases from roles Date: Mon, 16 Apr 2007 21:54:40 +0000 Mime-Version: 1.0 Content-Type: text/html; format=flowed X-OriginalArrivalTime: 16 Apr 2007 21:54:41.0781 (UTC) FILETIME=[D6445250:01C78071] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.407 tagged_above=0 required=5 tests=BAYES_50=0.001, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, HTML_40_50=0.496, HTML_MESSAGE=0.001, MIME_HTML_ONLY=0.001, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: ** X-Archive-Number: 200704/163 X-Sequence-Number: 25227
Hello,
 
I have a situation where one postgres instalation have many databases and roles. Each role can see only it's own database. The role CAN NOT see even table structures of other databases.
 
I create the databases setting it's ownership to the specific role/user, but when I login with an other, this user still can see the database structure of others databases.
 
Is there any special configuration I have to do to prevent this problem?
 
Thansk,
 
Diego de Lima


MSN Messenger: converse com os seus amigos online. Instale grátis. Clique aqui.