Hiding databases from roles - Mailing list pgsql-admin

From Diego de Lima
Subject Hiding databases from roles
Date
Msg-id BAY125-F2071F928057676468FC702A7520@phx.gbl
Whole thread Raw
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Auto vacuum
Next
From: "Hajek, Nick"
Date:
Subject: Re: Is anyone running version 8.2.3 on SuSE 10.2