get_permissions_for_user.sql
1SELECT
2 resource_type,
3 resource_id,
4 permissions
5FROM permissions
6WHERE
7 user_id = ?
8AND
9 resource_id IS NOT NULL
10ORDER BY resource_type, resource_id
rtw
Adventure motorcycling trip planning app. Check it out at https://rtw.run.