Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Possible incorrect granted permission in example RLS policy #35

Open
brandonw4 opened this issue Oct 31, 2024 · 0 comments · May be fixed by #36
Open

Possible incorrect granted permission in example RLS policy #35

brandonw4 opened this issue Oct 31, 2024 · 0 comments · May be fixed by #36

Comments

@brandonw4
Copy link

For the RLS example policy "Allow authenticated group members with any role to read groups"
Currently the permissive check is for all instead of for select.

-- Allow authenticated group members with any role to read groups
create policy "Members can read"
on "public"."groups"
as permissive
for all
to authenticated
using (user_is_group_member(id));

@brandonw4 brandonw4 linked a pull request Oct 31, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant