Date: Tue, 31 Mar 2015 11:35:06 -0300 (BRT)
From: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
To: pgsql-admin@postgresql.org
Message-ID: <1691459001.14399050.1427812506082.JavaMail.root@embrapa.br>
In-Reply-To: <1437490596.14394441.1427812231773.JavaMail.root@embrapa.br>
Subject: Catalog permissions
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----=_Part_14399049_1110832796.1427812506081"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

------=_Part_14399049_1110832796.1427812506081
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi, 

I have to allow one user to use my Postgres installation in one schema of several. We are preparing an phpPGAdmin installation to give an remote access to this schema. 
The phpPDAdmin is showing the entire catalog to this user and allowing access only in the schema that I gave permissions to him. 
How do I do to this user can see only the schema that he has access, not the entire catalog. 
Is it possible? 
Thanks, 
Bruno 


____________________________________________________________________________
Aviso de confidencialidade 

Esta mensagem da Empresa  Brasileira de Pesquisa  Agropecuaria  (Embrapa),
empresa publica federal  regida pelo disposto  na Lei Federal no. 5.851,  de
7 de dezembro de 1972,  e  enviada exclusivamente  a seu destinatario e pode
conter informacoes  confidenciais, protegidas  por sigilo profissional.  Sua
utilizacao desautorizada  e ilegal e  sujeita o infrator as penas da lei. Se
voce  a recebeu indevidamente, queira, por gentileza, reenvia-la ao emitente,
esclarecendo o equivoco.

Confidentiality note

This message from Empresa  Brasileira de Pesquisa  Agropecuaria  (Embrapa), a
government company  established under  Brazilian law  (5.851/72), is directed
exclusively to  its addressee  and may contain  confidential data,  protected
under  professional secrecy  rules. Its unauthorized  use is illegal and  may
subject the transgressor to the law's penalties. If you are not the addressee,
please send it back, elucidating the failure.


------=_Part_14399049_1110832796.1427812506081
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000'>Hi,<br><br>I have to allow one user to use my Postgres installation in one schema of several.&nbsp;
 We are preparing an phpPGAdmin installation to give an remote access to
 this schema.<br>The phpPDAdmin is showing the entire catalog to this user and allowing access only in the schema that I gave permissions to him. <br>How do I do to this user can see only the schema that he has access, not the entire catalog.<br>Is it possible?<br>Thanks,&nbsp; <br>Bruno <br><span></span><br><div><span name="x"></span><br></div></div>

<br>

<html>

<body>

<p align="left"><font size=1 >

<BR>____________________________________________________________________________

<BR>Aviso de confidencialidade.

<br><BR>

Esta mensagem da Empresa  Brasileira de Pesquisa  Agropecu&aacute;ria  (Embrapa),

empresa p&ugrave;blica federal  regida pelo disposto  na Lei Federal no. 5.851,  de

7 de dezembro de 1972,   &eacute;  enviada exclusivamente  a seu destinat&aacute;rio e pode

conter informa&ccedil;&otilde;es  confidenciais, protegidas  por sigilo profissional.  Sua

utiliza&ccedil;&atilde;o desautorizada  &eacute; ilegal e sujeita o infrator &agrave;s penas da lei. Se

voc&ecirc;  a recebeu indevidamente, queira, por gentileza, reenvi&aacute;-la ao emitente,

esclarecendo o equ&iacute;voco.

<BR><BR>

Confidentiality note

<BR><BR>

This message from Empresa  Brasileira de Pesquisa  Agropecu&aacute;ria  (Embrapa), a

government company  established under  Brazilian law  (5.851/72), is directed

exclusively to  its addressee  and may contain  confidential data,  protected

under  professional secrecy  rules. Its unauthorized  use is illegal and  may

subject the transgressor to the law's penalties. If you are not the addressee,

please send it back, elucidating the failure.

<BR>

</font>

</body>

</html>

<br>

</body></html>
------=_Part_14399049_1110832796.1427812506081--