From: Diego de Lima <diego_de_lima@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Hiding databases from roles
Date: Mon, 16 Apr 2007 21:54:40 +0000
Message-ID: <BAY125-F2071F928057676468FC702A7520@phx.gbl> (raw)
<html><div style='background-color:'><DIV class=RTE>Hello,</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>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.</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>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.</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Is there any special configuration I have to do to prevent this problem?</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Thansk,</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Diego de Lima</DIV></div><br clear=all><hr>MSN Messenger: converse com os seus amigos online. <a href="http://g.msn.com/8HMBENBR/2755??PS=47575"; target="_top">Instale grĂ¡tis. Clique aqui.</a> </html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: diego_de_lima@hotmail.com
Subject: Re: Hiding databases from roles
In-Reply-To: <BAY125-F2071F928057676468FC702A7520@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox