| | |
| | | INNER JOIN ${database}.object_data od2 ON od2.obj_id = rf.rol_id |
| | | WHERE od.\`type\` = "crs" |
| | | AND od2.title LIKE "%admin%" |
| | | AND t.deleted is NULL |
| | | ` |
| | | const [results] = await pool.query(q) |
| | | return results |
| | |
| | | INNER JOIN ${database}.rbac_fa rf ON rf.parent = t.ref_id |
| | | INNER JOIN ${database}.object_data od2 ON od2.obj_id = rf.rol_id |
| | | WHERE od.\`type\` = "crs" |
| | | AND od2.title LIKE "%admin%") adminRoles |
| | | AND od2.title LIKE "%admin%" |
| | | AND t.deleted is NULL) adminRoles |
| | | WHERE adminRoles.rol_id NOT IN (SELECT ru2.rol_id |
| | | FROM ${database}.rbac_ua ru2) |
| | | ` |