Hi DBA,
Just as the error message said ”The EXECUTE permission was denied on the object ‘HyperonExtract_Current’, database ‘xxxx’, schema ‘hyp’.”, the current use does not have permission to execute on the object ‘HyperonExtract_Current’, database ‘xxxx’, schema
‘hyp’.
To fix this issue, please grant the execute permission to the user with the query below:
USE xxxx;
GRANT EXEC ON hyp.HyperonExtract_Current TO user
References:
GRANT System Object Permissions (Transact-SQL)
The EXECUTE permission was denied on the object ‘sp_start_job’, database ‘msdb’, schema ‘dbo’.
Thanks,
Katherine Xiong
Katherine Xiong
TechNet Community Support
