Grant user permission to query tables and legacy views

Owned by Knowledge Assistant
Mar 14, 2022
1 min read





Description of Issue

User needs db_datareader permission to build report using tables.



Context

  • SSRS reports

  • Crystal reports

  • Munis all versions

  • SQL Server

  • db_datareader



Cause

Default configuration does not give end users access to tables and legacy views.



Resolution

This permission can only be granted by SQL Server administrators. To grant this permission, follow the steps below:

  1. Login and connect to Munis SQL Server using an administrator account.

  2. Expand the Security folder.

  3. Expand the Logins folder.

  4. Right click on username and select Properties

  5. In the pop-up window Login Properties, click User Mapping menu on the left.

  6.  Click once on Munis database in the top section.

  7. Select the option db_datareader and click OK.

This user now has permission to query all tables and legacy views through SSRS or Crystal reports.



Additional Information

This permission is only meant for few custom report authors and should never be assigned to Munis Users group.