fix: Use INSERT instead of UPDATE

Open filipecabaco opened this issue 1 year ago • 1 comments

What kind of change does this PR introduce?

Uses an INSERT RLS policy instead of a UPDATE to check if user can connect.

This is done by checking if the user was able to insert and it failed due to unique violation so they had permissions to try and insert.

May 02 '24 16:05 filipecabaco

The latest updates on your projects. Learn more about Vercel for Git ↗︎

1 Ignored Deployment

Name	Status	Preview	Updated (UTC)
realtime-demo	⬜️ Ignored (Inspect)		May 2, 2024 4:33pm

May 02 '24 16:05 vercel[bot]

we move out this system for authz

Jul 02 '24 08:07 filipecabaco