Help with policy condition
I have a public.users table that stores user data, whose id is a foreign key referencing the auth.users table. I want to set up a policy such that only the logged-in user (from auth.users) with the role='admin' in public.users will be able to modify the public.users table. Can someone assist me in creating this policy?
