Join Discord
Powered by
Is it possible to create a RLS policy where a user...
# off-topic
e
Eidur
05/30/2022, 5:36 PM
Is it possible to create a RLS policy where a user can read all of the data in a row but can only update some?
b
burggraf
05/30/2022, 7:14 PM
Of course you can do that. An RLS Policy is just a piece of SQL that gets added to the WHERE clause every time that record is accessed.
burggraf
05/30/2022, 7:14 PM
So if you can write a WHERE clause, you can write an RLS Policy (they're essentially the same thing)
Previous
Next