Catalog permissions

From: BRUNO CESAR BERNARDES <bruno(dot)bernardes(at)embrapa(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Catalog permissions
Date: 2015-03-31 14:35:06
Message-ID: 1691459001.14399050.1427812506082.JavaMail.root@embrapa.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gilberto Castillo 2015-03-31 14:42:06 Re: Permission select pg_stat_replication
Previous Message Gilberto Castillo 2015-03-31 14:29:44 Re: Permission select pg_stat_replication