Hiding databases from roles

From: "Diego de Lima" <diego_de_lima(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Hiding databases from roles
Date: 2007-04-16 21:54:40
Message-ID: BAY125-F2071F928057676468FC702A7520@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<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 grtis. Clique aqui.</a> </html>

Attachment Content-Type Size
unknown_filename text/html 951 bytes

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2007-04-16 22:08:54 Re: Vacuum stops with misleading max_fsm_pages error
Previous Message Kieran Cooper, Lyris UK 2007-04-16 21:51:41 Vacuum stops with misleading max_fsm_pages error