Message-ID: <38300.192.168.207.54.1427917847.squirrel@webmail.etecsa.cu>
In-Reply-To: <1809816788.15318923.1427913861185.JavaMail.root@embrapa.br>
References: <1809816788.15318923.1427913861185.JavaMail.root@embrapa.br>
Date: Wed, 1 Apr 2015 14:50:47 -0500 (GMT+5)
Subject: Re: Catalog permissions
From: "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
To: "BRUNO CESAR BERNARDES" <bruno.bernardes@embrapa.br>
Cc: "gilberto castillo" <gilberto.castillo@etecsa.cu>,
 pgsql-admin@postgresql.org
Reply-To: gilberto.castillo@etecsa.cu
User-Agent: SquirrelMail/1.4.8-5.el5_4.10
MIME-Version: 1.0
Importance: Normal
Content-Type: multipart/mixed; boundary="=tDo6uKQt61162=imx3.etecsa.cu="
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.

--=tDo6uKQt61162=imx3.etecsa.cu=
Content-Disposition: inline
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


> 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.


Or give permissions read only. That's what that passed through my lines.


> ----- 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 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.
>
>
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx2.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>


Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba

--=tDo6uKQt61162=imx3.etecsa.cu=
Content-Type: text/plain
Content-Disposition: inline

--- 
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>

--=tDo6uKQt61162=imx3.etecsa.cu=
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=tDo6uKQt61162=imx3.etecsa.cu=--