SAP B1 How to Set Query Authorization for Generating Reports Only in Limited Logistic Users

[Former Member]

Hi Experts,

Can anyone help me regarding to my concern, i want to set a query authorization in limited logistic users to generate a reports but an error appears.

Thank you & Best regards.

[Former Member]

Hi Erwin,

Symptom

When a user runs a SELECT query in the query generator or uses the query in FMS, and the authorization "Execute Non-select SQL Statement" for this user is set to "No Authorization", the application may display the following message: "Error while connecting read-only database user; check that the read-only user is assigned to company in database".

Cause

Consulting

Solution

The authorization "Execute Non-select SQL Statement" works only when a read-only user is correctly configured.

Refer to section 7.4.1. "Seeing Read-Only User Permissions" in SAP Business One 8.8 Administrator Guide for information on how to configure read-only users.

Other terms

Security, Permission, Read-Only DB User

read the above statements it may help you.

Regards,

Bhushan Verma

[former_member205766]

Hi Erwin

Check the below link it may helps you

With Regards

Balaji Sampath