On Thu, May 2, 2024 at 1:47 AM RAJAMOHAN wrote:
> Hello all,
>
> In our production db infrastructure, we have one read_only role which has
> read privileges against all tables in schema A.
>
> We are planning to grant this role to some developers for viewing the
> data, but also I want to limit
On Wednesday, May 1, 2024, RAJAMOHAN wrote:
>
> Main reason being I don't want the data to be copied from the database to
> their local machines.
>
You cannot stop it being copied to their local machine, you can only make
it difficult. And really not that difficult.
Trust but verify - i.e.,
Hi RAJAMOHAN
There is not a direct way to restrict a table not to be allowed to be
backed up by pg_dump.
But you can use the RLS (ROW LEVEL SECURITY) policy to restrict access.
Regards
Kashif Zeeshan
Bitnine Global
On Thu, May 2, 2024 at 10:47 AM RAJAMOHAN wrote:
> Hello all,
>
> In our
Hello all,
In our production db infrastructure, we have one read_only role which has
read privileges against all tables in schema A.
We are planning to grant this role to some developers for viewing the data,
but also I want to limit the users from executing statements like copy or
using
