Getting EXECUTE permission was denied on the object Error

building reports webintelligence
1

Hi

We are getting below error when we run the Stored Procedure Universe.

[Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object ‘USP_RPT_SGR_Indicator’, database ‘dQRSTran’, schema ‘dbo’… For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (WIS

Please help us to resolve this issue.

Thanks

antonynelsonbe (BOB member since 2015-09-28)

2

Hello,

I’m not familiar with stored procedures in BO, but couldn’t this be related to the fact that the user that BO uses to connect to the database doesn’t have enough permissions at database side?

Stef102 :belgium: (BOB member since 2014-08-05)