Question about RLS policy
I'd like to setup RLS policy only indicating that a row is allowed to delete when a referred row (by a foreign key) is deleted.
For example, I have two table, one is
When a row in a
How do you write the USING expression??
For example, I have two table, one is
user. another is articleWhen a row in a
user table is deleted, I want to allow the article table to delete all the rows connected by a foreign key with the user. How do you write the USING expression??