pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCatalog permissions
8+ messages / 4 participants
[nested] [flat]
* Catalog permissions
@ 2015-03-31 14:35 BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
0 siblings, 1 reply; 8+ messages in thread
From: BRUNO CESAR BERNARDES @ 2015-03-31 14:35 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Catalog permissions
@ 2015-03-31 15:59 Gilberto Castillo <gilberto.castillo@etecsa.cu>
parent: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
0 siblings, 2 replies; 8+ messages in thread
From: Gilberto Castillo @ 2015-03-31 15:59 UTC (permalink / raw)
To: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>; +Cc: 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?
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Catalog permissions
@ 2015-03-31 19:44 BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
parent: Gilberto Castillo <gilberto.castillo@etecsa.cu>
1 sibling, 1 reply; 8+ messages in thread
From: BRUNO CESAR BERNARDES @ 2015-03-31 19:44 UTC (permalink / raw)
To: gilberto castillo <gilberto.castillo@etecsa.cu>; +Cc: pgsql-admin
Thanks Gilberto,
The problem still the same.
The user is allowed to see the entire installation catalog, all databases, all schemas, etc. Of course, he is allowed to see data only in the schema that I gave this permission.
The ideia is to be shoed to him only the datbase end schema that he has permission.
I applied the command "Alter user myuser set default_transaction_read_only = on;" to this user . The others were already set.
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
-
________________________________________________________________________
____
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Catalog permissions
@ 2015-03-31 19:53 Felipe Santos <felipepts@gmail.com>
parent: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
0 siblings, 2 replies; 8+ messages in thread
From: Felipe Santos @ 2015-03-31 19:53 UTC (permalink / raw)
To: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>; +Cc: gilberto castillo <gilberto.castillo@etecsa.cu>; pgsql-admin
2015-03-31 16:44 GMT-03:00 BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br
>:
> Thanks Gilberto,
>
> The problem still the same.
> The user is allowed to see the entire installation catalog, all
> databases, all schemas, etc. Of course, he is allowed to see data only in
> the schema that I gave this permission.
> The ideia is to be shoed to him only the datbase end schema that he
> has permission.
> I applied the command "Alter user myuser set
> default_transaction_read_only = on;" to this user . The others were
> already set.
>
> Saludos,
> Bruno
>
> ------------------------------
> *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
>
>
>
> -
>
>
>
> ________________
> ____________________________________________________________
> Aviso de confidencialidade.
>
> Esta mensagem da Empresa Brasileira de Pesq uisa Agropecuária (Embrapa),
> empresa pùblica federal regi da pelo disposto na Lei Federal no. 5.851, de
> 7 de dezembro de 1972, & eacute; enviada exclusivamente a seu destinatário
> e pode conter i nformações confidenciais, protegidas por sigilo
> profissional . Sua utilização desautorizada é ilegal e sujeita o infrator
> às penas da lei. Se você a recebeu indevidamente, queira, por gentileza,
> reenviá-la ao emitente, esclarecendo o equ&i acute;voco.
>
> Confidentiality note
>
> This message from Empresa Brasileira de Pesquisa Agropecuária (Embrapa), a
> govern ment company established under Brazilian law (5.851/72), is directed
> ex clusively 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 a
> ddressee, please send it back, elucidating the failure.
>
>
Olá Bruno,
Is this what you are looking for?
Link:
http://stackoverflow.com/questions/12663639/how-to-hide-databases-that-i-am-not-allowed-to-access
Regards
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Catalog permissions
@ 2015-03-31 21:03 Guillaume Lelarge <guillaume@lelarge.info>
parent: Felipe Santos <felipepts@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Guillaume Lelarge @ 2015-03-31 21:03 UTC (permalink / raw)
To: Felipe Santos <felipepts@gmail.com>; +Cc: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>; gilberto castillo <gilberto.castillo@etecsa.cu>; pgsql-admin
2015-03-31 21:53 GMT+02:00 Felipe Santos <felipepts@gmail.com>:
>
>
> 2015-03-31 16:44 GMT-03:00 BRUNO CESAR BERNARDES <
> bruno.bernardes@embrapa.br>:
>
> Thanks Gilberto,
>>
>> The problem still the same.
>> The user is allowed to see the entire installation catalog, all
>> databases, all schemas, etc. Of course, he is allowed to see data only in
>> the schema that I gave this permission.
>> The ideia is to be shoed to him only the datbase end schema that he
>> has permission.
>> I applied the command "Alter user myuser set
>> default_transaction_read_only = on;" to this user . The others were
>> already set.
>>
>> Saludos,
>> Bruno
>>
>> ------------------------------
>> *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
>>
>>
>>
>> -
>>
>>
>>
>> ________________
>> ____________________________________________________________
>> Aviso de confidencialidade.
>>
>> Esta mensagem da Empresa Brasileira de Pesq uisa Agropecuária (Embrapa),
>> empresa pùblica federal regi da pelo disposto na Lei Federal no. 5.851, de
>> 7 de dezembro de 1972, & eacute; enviada exclusivamente a seu destinatário
>> e pode conter i nformações confidenciais, protegidas por sigilo
>> profissional . Sua utilização desautorizada é ilegal e sujeita o infrator
>> às penas da lei. Se você a recebeu indevidamente, queira, por gentileza,
>> reenviá-la ao emitente, esclarecendo o equ&i acute;voco.
>>
>> Confidentiality note
>>
>> This message from Empresa Brasileira de Pesquisa Agropecuária (Embrapa),
>> a govern ment company established under Brazilian law (5.851/72), is
>> directed ex clusively 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
>> a ddressee, please send it back, elucidating the failure.
>>
>>
>
> Olá Bruno,
>
> Is this what you are looking for?
>
> Link:
> http://stackoverflow.com/questions/12663639/how-to-hide-databases-that-i-am-not-allowed-to-access
>
>
This will only work on pgAdmin. There's no such capacity in phpPgAdmin.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Catalog permissions
@ 2015-04-01 18:42 BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
parent: Felipe Santos <felipepts@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: BRUNO CESAR BERNARDES @ 2015-04-01 18:42 UTC (permalink / raw)
To: Felipe Santos <felipepts@gmail.com>; +Cc: gilberto castillo <gilberto.castillo@etecsa.cu>; pgsql-admin
Dear Felipe,
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.
Best regards,
----- Mensagem original -----
De: "Felipe Santos" <felipepts@gmail.com>
Para: "BRUNO CESAR BERNARDES" <bruno.bernardes@embrapa.br>
Cc: "gilberto castillo" <gilberto.castillo@etecsa.cu>, pgsql-admin@postgresql.org
Enviadas: Terça-feira, 31 de março de 2015 16:53:29
Assunto: Re: [ADMIN] Catalog permissions
2015-03-31 16:44 GMT-03:00 BRUNO CESAR BERNARDES < bruno.bernardes@embrapa.br > :
Thanks Gilberto,
The problem still the same.
The user is allowed to see the entire installation catalog, all databases, all schemas, etc. Of course, he is allowed to see data only in the schema that I gave this permission.
The ideia is to be shoed to him only the datbase end schema that he has permission.
I applied the command "Alter user myuser set default_transaction_read_only = on;" to this user . The others were already set.
Saludos,
Bruno
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
-
________________ ____________________________________________________________
Aviso de confidencialidade.
Esta mensagem da Empresa Brasileira de Pesq uisa Agropecuária (Embrapa), empresa pùblica federal regi da pelo disposto na Lei Federal no. 5.851, de 7 de dezembro de 1972, & eacute; enviada exclusivamente a seu destinatário e pode conter i nformações confidenciais, protegidas por sigilo profissional . Sua utilização desautorizada é ilegal e sujeita o infrator às penas da lei. Se você a recebeu indevidamente, queira, por gentileza, reenviá-la ao emitente, esclarecendo o equ&i acute;voco.
Confidentiality note
This message from Empresa Brasileira de Pesquisa Agropecuária (Embrapa), a govern ment company established under Brazilian law (5.851/72), is directed ex clusively 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 a ddressee, please send it back, elucidating the failure.
Olá Bruno,
Is this what you are looking for?
Link: http://stackoverflow.com/questions/12663639/how-to-hide-databases-that-i-am-not-allowed-to-access
Regards
--
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Catalog permissions
@ 2015-04-01 18:44 BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
parent: Gilberto Castillo <gilberto.castillo@etecsa.cu>
1 sibling, 1 reply; 8+ messages in thread
From: BRUNO CESAR BERNARDES @ 2015-04-01 18:44 UTC (permalink / raw)
To: gilberto castillo <gilberto.castillo@etecsa.cu>; +Cc: pgsql-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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Catalog permissions
@ 2015-04-01 19:50 Gilberto Castillo <gilberto.castillo@etecsa.cu>
parent: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
0 siblings, 0 replies; 8+ messages in thread
From: Gilberto Castillo @ 2015-04-01 19:50 UTC (permalink / raw)
To: BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>; +Cc: gilberto castillo <gilberto.castillo@etecsa.cu>; pgsql-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.
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
---
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
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2015-04-01 19:50 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-03-31 14:35 Catalog permissions BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
2015-03-31 15:59 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
2015-03-31 19:44 ` BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
2015-03-31 19:53 ` Felipe Santos <felipepts@gmail.com>
2015-03-31 21:03 ` Guillaume Lelarge <guillaume@lelarge.info>
2015-04-01 18:42 ` BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
2015-04-01 18:44 ` BRUNO CESAR BERNARDES <bruno.bernardes@embrapa.br>
2015-04-01 19:50 ` Gilberto Castillo <gilberto.castillo@etecsa.cu>
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