From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ankur Kaushik <ankurkaushik(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: New table not have access for read only user |
Date: | 2024-02-28 12:46:11 |
Message-ID: | CAKFQuwZKFNvpYPBSpQkTe6kqfZ8GBozfvAjkdDHtpTGM2ekVXg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wednesday, February 28, 2024, Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
wrote:
> 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. ?
>
Use the alter default privileges command.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Sundeep Kumar | 2024-02-28 12:46:55 | Re: New table not have access for read only user |
Previous Message | Ankur Kaushik | 2024-02-28 12:40:35 | New table not have access for read only user |