Subscribe to a channel using a key
Hi everyone,
I have a "results" table that are secured by RLS with the policy where authenticated users can see their own results. I also have a table "tokens" that is used for un-authenticated user to add results using a rpc function that takes the key as an argument.
I would like for a un-authenticated user to be able to subscribe to the "results" table by giving the key corresponding the "token" that is related to the result.
Do you know if it is possible? Or maybe have an idea on how to "hack around" that difficulty?
Thank you for your time
I have a "results" table that are secured by RLS with the policy where authenticated users can see their own results. I also have a table "tokens" that is used for un-authenticated user to add results using a rpc function that takes the key as an argument.
I would like for a un-authenticated user to be able to subscribe to the "results" table by giving the key corresponding the "token" that is related to the result.
Do you know if it is possible? Or maybe have an idea on how to "hack around" that difficulty?
Thank you for your time
