pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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>&nbsp;</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&nbsp;see even table structures of other databases.</DIV>
<DIV class=RTE>&nbsp;</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>&nbsp;</DIV>
<DIV class=RTE>Is there any special configuration I have to do to prevent this problem?</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE>Thansk,</DIV>
<DIV class=RTE>&nbsp;</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>




Message-ID: <BAY125-F2071F928057676468FC702A7520@phx.gbl>
Permalink:  ../BAY125-F2071F928057676468FC702A7520@phx.gbl/
Also on:    postgresql.org/message-id/BAY125-F2071F928057676468FC702A7520@phx.gbl

 · 

reply

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