## Atul Kumar (akumar14...@gmail.com):
> Then I granted default "select" privileges to reader *user *to read data of
> all tables created by writer *user* using below command:
>
> alter default privileges in schema grant select on tables
> to .
"ALTER DEFAULT PRIVILEGES allows you to set the pr
On Friday, August 30, 2024, Atul Kumar wrote:
>
>
> I have a postgres instance running on version 15 in centos7.
>
> I have created a custom database and revoked all public privileges from
> that database.
>
Would be better to provide the actual psql script of what you’ve done
instead of writing
Hi.
I think the ALTER DEFAULT PRIVILEGES command affects only tables that are
created after the command is executed. Tables created by the writer user
before you executed the ALTER DEFAULT PRIVILEGES command would not
automatically have select privileges granted to the reader user. You can
try by
Hi,
I have a postgres instance running on version 15 in centos7.
I have created a custom database and revoked all public privileges from
that database.
Then I have created a custom schema in that custom database.
Now I have created one writer *user* and one reader *user *by postgres
superuser a
