Hi, why can't I see my own attendance if I use thi...
# help
s
Hi, why can't I see my own attendance if I use this policy?
Copy code
ALTER POLICY "only own user can see attendance" IN public.attendance USING (( EXISTS ( SELECT 1 FROM profile WHERE (profile.id = attendance.profile_id) ) )))) ;
return empty from server . I just want to learn how the policy rules work. if I try
Copy code
auth.uid() = profile_id
it works.
n
Hello @singgih! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the
/title
command! We have solved your problem? Click the button below to archive it.
Thread was archived by @singgih. Anyone can send a message to unarchive it.
singgih (2022-03-21)
g
Do you have read access policy on profile table?
s
my bad I was wrong in the query expression, and now it works