You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
event
- id
- host_id
- ...
event_attendees
- id
- event_id
- user_id
- token
- muted
- ...
Assume a simple FK relation between event and event_attendees
Permissions
Attendees can only see rows in event_attendee that are theirs. All fields
Attendees can update event_attendee.muted for their own rows
Event hosts CANNOT see ANY row in event_attendee
Event hosts can update event_attendee.muted for events for which they are host.
See below screenshots for the setup
Issue
If I do a query as a host, I cannot see any row in event_attendees, which is correct But if I do an update as a host, I can see all the data for the updated row !
Is this by design ? Does not make sense logically
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Lets take 2 tables
Assume a simple FK relation between
event
andevent_attendees
Permissions
event_attendee
that are theirs. All fieldsevent_attendee.muted
for their own rowsevent_attendee
event_attendee.muted
for events for which they are host.See below screenshots for the setup
Issue
If I do a query as a host, I cannot see any row in
event_attendees
, which is correctBut if I do an update as a host, I can see all the data for the updated row !
Is this by design ? Does not make sense logically
Screenshots of permissions on
event_attendee
Beta Was this translation helpful? Give feedback.
All reactions