| From: | "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu> |
|---|---|
| To: | "BRUNO CESAR BERNARDES" <bruno(dot)bernardes(at)embrapa(dot)br> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Catalog permissions |
| Date: | 2015-03-31 15:59:11 |
| Message-ID: | 46538.192.168.207.54.1427817551.squirrel@webmail.etecsa.cu |
| 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?
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
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 179 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jesse.waters | 2015-03-31 17:52:42 | Re: Permission select pg_stat_replication |
| Previous Message | Gilberto Castillo | 2015-03-31 14:47:45 | Re: Permission select pg_stat_replication |