From: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
To: pgsql-admin@postgresql.org
Subject: Catalog permissions
Date: Tue, 31 Mar 2015 11:35:06 -0300 (BRT)
Message-ID: <1691459001.14399050.1427812506082.JavaMail.root@embrapa.br> (raw)
In-Reply-To: <1437490596.14394441.1427812231773.JavaMail.root@embrapa.br>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
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: bruno.bernardes@embrapa.br
Subject: Re: Catalog permissions
In-Reply-To: <1691459001.14399050.1427812506082.JavaMail.root@embrapa.br>
* 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