Recommend to create a Read-only SQL user for configuration in Crystal Report design. In order to run a stored procedure in a report, you will need to grant the required access rights to create/modify and execute stored procedure.


STEP 1 - At SQL Server - Security - Login : Create a new SQL User, eg. SAP_REPORT


STEP 2 - Server Roles, make sure new SQL user is assigned to public Role only.


Step 3 - User Mapping, select the relevant SAP Company Database and assign Read-only database Membership.


Step 4 - At the SAP Database, Create a new Security Group with below script:  


-- Create New Role
CREATE ROLE db_storedprod;
GO

--Grant EXECUTE permission at the schema level.
GRANT EXECUTE ON SCHEMA::dbo TO db_storedprod;
GRANT CREATE PROCEDURE TO db_storedprod;
GRANT ALTER ON SCHEMA::dbo TO db_storedprod;

EXEC sp_addrolemember db_storedprod, SAP_REPORT
GO


Step 5 - Review the new user is mapped to new 'db_storedprod' security group.