Postgres/Postgis : setting up rls policies
1
vote
1
answer
118
views
So i'm trying to configure the different accesses for mutliple users to my postgres/postgis database.
Basically I have 1 manager user and 4 weak users accessing the db.
What I would like to do is to prevent a weak user to be able to delete entries that have been made by an another user in the database. BUT all users should still be able to see all entries from all users in the db.
So i'm wondering what combination of permissive and restrictive rls policies i should set up to make it work?
Thanks for your help guys!
Asked by tonyduky
(111 rep)
Sep 26, 2021, 05:32 PM
Last activity: Sep 27, 2021, 12:57 PM
Last activity: Sep 27, 2021, 12:57 PM