/
Grant user permission to query tables and legacy views

Grant user permission to query tables and legacy views





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.











Related content

DataSet error when trying to view canned SSRS reports
DataSet error when trying to view canned SSRS reports
More like this
Add munisusers active directory group to SQL Server logins
Add munisusers active directory group to SQL Server logins
More like this
Setup new user for SSRS custom reporting in SaaS
Setup new user for SSRS custom reporting in SaaS
More like this
How to grant permissions for user to access Cubes
How to grant permissions for user to access Cubes
More like this
Error Running Canned SSRS Reports from Munis - This report requires a default or user-defined value for the report parameter 'ReportYear'
Error Running Canned SSRS Reports from Munis - This report requires a default or user-defined value for the report parameter 'ReportYear'
More like this
How to grant Tyler Reporting Views to a user
How to grant Tyler Reporting Views to a user
More like this