Re: Restricting user to see schema structure - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Restricting user to see schema structure
Date
Msg-id 16a9c9a8-77e8-2805-bb6e-f8dc0abb9788@aklaver.com
Whole thread Raw
In response to Re: Restricting user to see schema structure  (Neeraj M R <neerajmr12219@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Restricting user to see schema structure
Next
From: Adrian Klaver
Date:
Subject: Re: Restricting user to see schema structure