Comment by abyesilyurt

I use row level security in postgres. Then you can set read only permissions.