List of all Roles that grant a permission in Munis

User needs a list of all Roles that grant a given permission to assigned users.

• Munis 11.3, 2019.1

• SSRS Reports

• Crystal Reports

• SaaS, Tyler-Hosted Clients

• OnPrem, Self-Hosted Clients

• Roles

• Effective Permissions

A built in report is not available that provides list of all roles, that grants a given permission in Munis

The view sp_role_permission will list each permission in Munis, Role key and a flag representing whether the role has that specific permission or not.

In the following sample query, replace XXXX in Line 7 with the full name of the permission to get a list of all roles that grant this permission to assigned users.

SELECT DISTINCT a_role_key,

a_top_mod_code,

mt_top_module_desc,

a_permission_key,

pd_permission,

rp_value FROM sp_role_permission

WHERE pd_permission = 'XXXX'

AND rp_value <> 'N'

To view a list of all permissions in Munis, follow the steps below:

1. Navigate to Munis > System Administration > Security > User Attributes

2. Search for any user and click on EFFECTIVE PERMISSIONS tab.

3. Full names of all permissions are listed under column Permission

Report for Role and menu access granted to users