Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YdNcy-0000Ix-0a for pgsql-admin@arkaria.postgresql.org; Wed, 01 Apr 2015 18:44:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YdNcx-0002DR-EM for pgsql-admin@arkaria.postgresql.org; Wed, 01 Apr 2015 18:44:35 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YdNcv-0002AT-CF for pgsql-admin@postgresql.org; Wed, 01 Apr 2015 18:44:33 +0000 Received: from mamona.sede.embrapa.br ([200.202.168.1]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YdNcq-00050m-RL for pgsql-admin@postgresql.org; Wed, 01 Apr 2015 18:44:31 +0000 Received: by mamona.sede.embrapa.br (Postfix, from userid 496) id 83A451C2E57; Wed, 1 Apr 2015 15:44:27 -0300 (BRT) Received: from zmta05.sede.embrapa.br (zmta05.sede.embrapa.br [10.170.20.75]) by mamona.sede.embrapa.br (Postfix) with ESMTP id BA2C31C2E28; Wed, 1 Apr 2015 15:44:25 -0300 (BRT) Received: from localhost (localhost.localdomain [127.0.0.1]) by zmta05.sede.embrapa.br (Postfix) with ESMTP id DF634285784; Wed, 1 Apr 2015 15:44:25 -0300 (BRT) X-Virus-Scanned: amavisd-new at zmta05.sede.embrapa.br Received: from zmta05.sede.embrapa.br ([127.0.0.1]) by localhost (zmta05.sede.embrapa.br [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id QCBCe1jJxEi1; Wed, 1 Apr 2015 15:44:21 -0300 (BRT) Received: from zmbox03.sede.embrapa.br (zmbox03.sede.embrapa.br [10.170.20.185]) by zmta05.sede.embrapa.br (Postfix) with ESMTP id 37E3A285783; Wed, 1 Apr 2015 15:44:21 -0300 (BRT) Date: Wed, 1 Apr 2015 15:44:21 -0300 (BRT) From: BRUNO CESAR BERNARDES To: gilberto castillo Cc: pgsql-admin@postgresql.org Message-ID: <1809816788.15318923.1427913861185.JavaMail.root@embrapa.br> In-Reply-To: <46538.192.168.207.54.1427817551.squirrel@webmail.etecsa.cu> Subject: Re: Catalog permissions MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_15318922_1891406126.1427913861183" X-Originating-IP: [200.202.168.177] X-Mailer: Zimbra 7.2.4_GA_2900 (ZimbraWebClient - FF3.0 (Linux)/7.2.4_GA_2900) X-Copyrighted-Material: Please visit http://www.embrapa.br X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_15318922_1891406126.1427913861183 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Dear Gilberto,=20 No. I am not using PgAdmin3, I am using PgPHPAdmin and I could not find a s= imilar option on it.=20 To solve my problem the best thing would be restrict the Postgres catalog t= o the objects that the user has permission.=20 Saludos,=20 Bruno=20 ----- Mensagem original ----- De: "Gilberto Castillo" =20 Para: "BRUNO CESAR BERNARDES" =20 Cc: pgsql-admin@postgresql.org=20 Enviadas: Ter=E7a-feira, 31 de mar=E7o de 2015 12:59:11=20 Assunto: Re: [ADMIN] Catalog permissions=20 > Hi,=20 >=20 > I have to allow one user to use my Postgres installation in one schema of= =20 > several. We are preparing an phpPGAdmin installation to give an remote=20 > access to this schema.=20 > The phpPDAdmin is showing the entire catalog to this user and allowing=20 > access only in the schema that I gave permissions to him.=20 > How do I do to this user can see only the schema that he has access, not= =20 > the entire catalog.=20 > Is it possible?=20 Use:=20 GRANT usage on schema zzz to uuu;=20 Alter user uuu set default_transaction_read_only =3D on;=20 GRANT select on all tables in schema zzz to uuu;=20 Saludos,=20 Gilberto Castillo=20 ETECSA, La Habana, Cuba=20 ---=20 This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running= at host imx3.etecsa.cu=20 Visit our web-site: , = =20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)=20 To make changes to your subscription:=20 http://www.postgresql.org/mailpref/pgsql-admin=20 --=20 Bruno C=E9sar Bernardes, Analista=20 Coordenadoria de Gest=E3o de Infraestrutura=20 Departamento de Tecnologia da Informa=E7=E3o (DTI)=20 Empresa Brasileira de Pesquisa Agropecu=E1ria (Embrapa)=20 Bras=EDlia/DF=20 bruno.bernardes@embrapa.br=20 Telefone: +55 (61) 3448-1637 | Fax: +55 (61) 3448-4313=20 www.embrapa.br | twitter.com/embrapa=20 Confira tamb=E9m: www.facebook.com/agrosustentavel=20 =0A________________________________________________________________________= ____=0AAviso de confidencialidade =0A=0AEsta mensagem da Empresa Brasileira= de Pesquisa Agropecuaria (Embrapa),=0Aempresa publica federal regida pel= o disposto na Lei Federal no. 5.851, de=0A7 de dezembro de 1972, e envia= da exclusivamente a seu destinatario e pode=0Aconter informacoes confidenc= iais, protegidas por sigilo profissional. Sua=0Autilizacao desautorizada = e ilegal e sujeita o infrator as penas da lei. Se=0Avoce a recebeu indevid= amente, queira, por gentileza, reenvia-la ao emitente,=0Aesclarecendo o equi= voco.=0A=0AConfidentiality note=0A=0AThis message from Empresa Brasileira d= e Pesquisa Agropecuaria (Embrapa), a=0Agovernment company established und= er Brazilian law (5.851/72), is directed=0Aexclusively to its addressee = and may contain confidential data, protected=0Aunder professional secrecy= rules. Its unauthorized use is illegal and may=0Asubject the transgresso= r to the law's penalties. If you are not the addressee,=0Aplease send it bac= k, elucidating the failure.=0A=0A=0A ------=_Part_15318922_1891406126.1427913861183 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: arial,helvetica,sans-serif; font-size: 12pt; colo= r: #000000'>Dear Gilberto,

   No. I am not using PgAdmin3,= I am using PgPHPAdmin and I could not find a similar option on it.
&nbs= p; To solve my problem the best thing would be restrict the Postgres catalo= g to the objects that the user has permission.

Saludos,
Bruno
=

De: "Gilberto Castillo" <gilberto.castillo@etecsa.c= u>
Para: "BRUNO CESAR BERNARDES" <bruno.bernardes@embrapa.b= r>
Cc: pgsql-admin@postgresql.org
Enviadas: Ter=E7a-= feira, 31 de mar=E7o de 2015 12:59:11
Assunto: Re: [ADMIN] Catalo= g permissions



> Hi,
>
> I have to allow one u= ser to use my Postgres installation in one schema of
> several. We ar= e preparing an phpPGAdmin installation to give an remote
> access to = this schema.
> The phpPDAdmin is showing the entire catalog to this u= ser 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 ha= s access, not
> the entire catalog.
> Is it possible?

Us= e:

GRANT usage on schema zzz to uuu;
Alter user uuu set default_t= ransaction_read_only =3D 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/R= ELEASE 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 chang= es to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin<= br>



--
Bruno C=E9sar Bern= ardes, Analista
Coordenadoria de Gest=E3o de Infraestrutura
Departame= nto de Tecnologia da Informa=E7=E3o (DTI)
Empresa Brasileira de Pesquisa= Agropecu=E1ria (Embrapa)
Bras=EDlia/DF

bruno.bernardes@embrapa.b= r
Telefone: +55 (61) 3448-1637  |  Fax: +55 (61) 3448-4313&nbs= p;    
www.embrapa.br | twitter.com/embrapa
Conf= ira tamb=E9m: www.facebook.com/agrosustentavel



= =0A=0A

=0A
________________= ____________________________________________________________=0A
Aviso de = confidencialidade.=0A

=0AEsta mensagem da Empresa Brasileira de Pesq= uisa Agropecuária (Embrapa),=0Aempresa pùblica federal regi= da pelo disposto na Lei Federal no. 5.851, de=0A7 de dezembro de 1972, &= eacute; enviada exclusivamente a seu destinatário e pode=0Aconter i= nformações confidenciais, protegidas por sigilo profissional= . Sua=0Autilização desautorizada é ilegal e sujeita o= infrator às penas da lei. Se=0Avocê a recebeu indevidamente, = queira, por gentileza, reenviá-la ao emitente,=0Aesclarecendo o equ&i= acute;voco.=0A

=0AConfidentiality note=0A

=0AThis message from= Empresa Brasileira de Pesquisa Agropecuária (Embrapa), a=0Agovern= ment company established under Brazilian law (5.851/72), is directed=0Aex= clusively to its addressee and may contain confidential data, protected= =0Aunder professional secrecy rules. Its unauthorized use is illegal and = may=0Asubject the transgressor to the law's penalties. If you are not the a= ddressee,=0Aplease send it back, elucidating the failure.=0A
=0A= =0A=0A=0A
= ------=_Part_15318922_1891406126.1427913861183--