Query to show permissions for roles created. (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306)
Go to Reports-New Query Report and execute the query.
select AaaRole.NAME "Role name", ar.name "Permission" from AaaRole inner join AaaImpliedRole on AaaRole.ROLE_ID=AaaImpliedRole.ROLE_ID
left join aaarole ar on aaaimpliedrole.impliedrole_id=ar.role_id order by 1, 2
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?