Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: unknown_filename
Description: text/html (951 bytes)

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group