get_permission.sql
1-- get_permission.sql
2SELECT permissions FROM abac
3WHERE
4 resource_type=?
5AND
6 (resource_id=? OR resource_id IS NULL)
7AND
8 (user_id=? OR user_id IS NULL)
9ORDER BY
10 user_id NULLS LAST,
11 resource_id NULLS LAST,
12 permissions DESC
13LIMIT 1;
14