set_permission_for_user.sql
1-- set_permission_for_user.sql
2INSERT INTO permissions (resource_type, resource_id, user_id, permissions)
3 VALUES (?, ?, ?, ?)
4ON CONFLICT
5 DO UPDATE SET permissions=excluded.permissions;
6
Adventure motorcycling trip planning app. Check it out at https://rtw.run.
1-- set_permission_for_user.sql
2INSERT INTO permissions (resource_type, resource_id, user_id, permissions)
3 VALUES (?, ?, ?, ?)
4ON CONFLICT
5 DO UPDATE SET permissions=excluded.permissions;
6