From: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
To: gilberto castillo <gilberto.castillo@etecsa.cu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Catalog permissions
Date: Wed, 1 Apr 2015 15:44:21 -0300 (BRT)
Message-ID: <1809816788.15318923.1427913861185.JavaMail.root@embrapa.br> (raw)
In-Reply-To: <46538.192.168.207.54.1427817551.squirrel@webmail.etecsa.cu>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Dear Gilberto,
No. I am not using PgAdmin3, I am using PgPHPAdmin and I could not find a similar option on it.
To solve my problem the best thing would be restrict the Postgres catalog to the objects that the user has permission.
Saludos,
Bruno
----- Mensagem original -----
De: "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
Para: "BRUNO CESAR BERNARDES" <bruno.bernardes@embrapa.br>
Cc: pgsql-admin@postgresql.org
Enviadas: Terça-feira, 31 de março de 2015 12:59:11
Assunto: Re: [ADMIN] Catalog permissions
> 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?
Use:
GRANT usage on schema zzz to uuu;
Alter user uuu set default_transaction_read_only = on;
GRANT select on all tables in schema zzz to uuu;
Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com;, <http://www.viruslist.com;
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Bruno César Bernardes, Analista
Coordenadoria de Gestão de Infraestrutura
Departamento de Tecnologia da Informação (DTI)
Empresa Brasileira de Pesquisa Agropecuária (Embrapa)
Brasília/DF
bruno.bernardes@embrapa.br
Telefone: +55 (61) 3448-1637 | Fax: +55 (61) 3448-4313
www.embrapa.br | twitter.com/embrapa
Confira também: www.facebook.com/agrosustentavel
________________________________________________________________________
____
Aviso de confidencialidade
Esta mensagem da Empresa Brasileira
de Pesquisa Agropecuaria (Embrapa),
empresa publica federal regida pel
o disposto na Lei Federal no. 5.851, de
7 de dezembro de 1972, e envia
da exclusivamente a seu destinatario e pode
conter informacoes confidenc
iais, protegidas por sigilo profissional. Sua
utilizacao desautorizada
e ilegal e sujeita o infrator as penas da lei. Se
voce a recebeu indevid
amente, queira, por gentileza, reenvia-la ao emitente,
esclarecendo o equi
voco.
Confidentiality note
This message from Empresa Brasileira d
e Pesquisa Agropecuaria (Embrapa), a
government company established und
er 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 transgresso
r to the law's penalties. If you are not the addressee,
please send it bac
k, 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, gilberto.castillo@etecsa.cu
Subject: Re: Catalog permissions
In-Reply-To: <1809816788.15318923.1427913861185.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