New table not have access for read only user

From: Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: New table not have access for read only user
Date: 2024-02-28 12:40:35
Message-ID: CALXoLqweaGWKNnLeHmN1eDNXx88AgwzcK_VM4J70-DoveM-SKw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi ,

I am making the user in postgresql 14.7 as below commands

\c dbname;
CREATE USER report_reader WITH PASSWORD 'xyz';
GRANT SELECT ON ALL TABLES IN SCHEMA public TO report_reader;
GRANT SELECT ON ALL TABLES IN SCHEMA schema1 TO report_reader;
GRANT USAGE ON SCHEMA schema1 TO report_reader ;

When the new table is added , report_reader not able to see show permission
denied.

After executing the below command able to read
GRANT SELECT ON ALL TABLES IN SCHEMA schema1 TO report_reader;

So How we can make to read only user new tables are able to show by itself.
?

Thanks and Regards
Ankur

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2024-02-28 12:46:11 Re: New table not have access for read only user
Previous Message Rajesh Kumar 2024-02-28 06:01:21 Mean_exec_time