Report on Permissions associated for Roles
DB : Mysql / MSSql
Build : 8011
Sample Report
Query :
SELECT AAAROLE.NAME 'Role', ar.NAME 'Permission' FROM AAAIMPLIEDROLE LEFT JOIN AAAROLE ON AAAROLE.ROLE_ID=AAAIMPLIEDROLE.ROLE_ID LEFT JOIN AAAROLE ar ON ar.ROLE_ID=AAAIMPLIEDROLE.IMPLIEDROLE_ID WHERE AAAROLE.ROLE_ID IN (SELECT ROLE_ID FROM AAAROLE WHERE SERVICE_ID=5);