Hi Bryn,
What I meant by 'created a new user' is that I have used the following
commands.
CREATE USER WITH ENCRYPTED PASSWORD '';
GRANT CONNECT ON DATABASE TO ;
GRANT USAGE ON SCHEMA TO ;
Thanks & Regards
Neeraj
On Fri, May 13, 2022, 10:43 Bryn Llewellyn wrote:
> *neerajmr12...@gmail.com
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 acces
Hi,
Is there anyway that we can restrict a user from seeing the schema
structure. I can restrict the user from accessing the data in the schema
but the user is still able to see the table names and what all columns are
present in them.
Thanks & Regards
Neeraj
