> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
