Do you know the exact permissions a user needs to run queries in SAP Business One?

Do you know the exact permissions a user needs to run queries in SAP Business One?

Here's a quick guide to setting it up:

? Step 1: Grant Query Groups Permissions
Go to: Administration → System Initialization → Authorizations → General Authorizations
Navigate to Reports → Query Generator
? Set Read-Only permissions for the specific query groups the user needs to access.
? Set Full Authorization for the Query Manager. 

? Step 2: Allow Execution of Stored Procedures or Views (if needed)
If your query involves a stored procedure or a view, be sure to enable:
Execute Non-Select SQL Statements
By following these steps, you'll ensure users can access only the queries they need, while keeping your database secure.