Forum Discussion
Solved
EXECUTE Permission denied
I saw a similar post...but my issue is slightly different. I am getting the failure on only one of two stored procs. The service account is a dbo to the database Other proc or views access tables ...
Have you tried specifically granting EXEC rights to that service account in SQL?
USE EF_DW
GO
GRANT Execute ON [dbo].proc_rpt_currencyexchangerates TO 'domain\service_account'
Have you tried specifically granting EXEC rights to that service account in SQL?
USE EF_DW
GO
GRANT Execute ON [dbo].proc_rpt_currencyexchangerates TO 'domain\service_account'