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

From Bryn Llewellyn
Subject Re: Restricting user to see schema structure
Date
Msg-id E92A52A6-ACA5-4CDD-B65A-624A2B335E65@yugabyte.com
Whole thread Raw
In response to Restricting user to see schema structure  (Neeraj M R <neerajmr12219@gmail.com>)
Responses Re: Restricting user to see schema structure
Re: Restricting user to see schema structure
List pgsql-general
neerajmr12219@gmail.com wrote:

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.

What exactly do you mean by "have created a new user and granted connection access to database"? As I understand it, there's no such thing. I mentioned a simple test in my earlier email that showed that any user (with no schema of its own and no granted privileges) can connect to any database—and see the full metadata account of all its content. I'm teaching myself to live with this.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Restricting user to see schema structure
Next
From: Neeraj M R
Date:
Subject: Re: Restricting user to see schema structure