Best way to implement anonymous access?
I have a table called 'events' with just a few columns (id, date, userid, uuid, etc) and I want authenticated users to be able to SELECT only their own events, (this was easy 'auth.uid() = userid')
but I also want to enable anon users to select SINGLE records for which they already have the uuid, kindof like a passphrase. So anon users would only be limited to SELECT ... from events where uuid = (somehow the querying user has to provide a uuid)
I'm somewhat new to Postgres specifically so I'm not even sure the best way to approach this.
Help appreciated and hopefully I described this well enough.
but I also want to enable anon users to select SINGLE records for which they already have the uuid, kindof like a passphrase. So anon users would only be limited to SELECT ... from events where uuid = (somehow the querying user has to provide a uuid)
I'm somewhat new to Postgres specifically so I'm not even sure the best way to approach this.
Help appreciated and hopefully I described this well enough.
