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@aklaver.com