| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Neeraj M R <neerajmr12219(at)gmail(dot)com>, Bryn Llewellyn <bryn(at)yugabyte(dot)com> |
| Cc: | Tom Lane PostgreSQL <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Restricting user to see schema structure |
| Date: | 2022-05-13 15:16:25 |
| Message-ID: | 16a9c9a8-77e8-2805-bb6e-f8dc0abb9788@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-05-13 15:30:30 | Re: Restricting user to see schema structure |
| Previous Message | David G. Johnston | 2022-05-13 13:47:43 | Re: Restricting user to see schema structure |