On 5/12/22 22:03, Neeraj M R wrote:
Hi all,
Thanks for your suggestions, I would like to define my problem a little
more.
I am using pgAdmin . I have a database 'db' and it has got 2 schemas
'schema1' and 'schema2', I have created some views in schema2 from
tables of schema1. I have created a new user and granted connection
access to database and granted usage on tables and views of schema2
only. But now the problem is that the new user is able to see the table
names of schema1 even though the user cannot see the data present in
them they can see the table names.Is there any way I can completely hide
schema1 from the new user.
AFAIK, you can't change that display in pgAdmin4. It would not help in
any case as long as the Query Tool is available as a user can get the
information the same way pgAdmin4 does, by querying the system catalogs.
Thanks & Regards
Neeraj
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
