Re: Restricting user to see schema structure

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