Calling a Web API from a stored procedure in the RDS hosted MSSQL Server

0

A lot of stored procedure in the migrated database called a web API to process complicated data. However, during the RDS migration, we are only given "admin" user with limited access causing some of the Stored Procedures to fail.

The EXECUTE permission was denied on the object 'sp_OACReate', database 'mssqlsystemsource',schema 'sys'.

I've done a lot of google search, unfortunately none provided a concrete solution. Can anybody guide us on how to solve this issue?

Thank you in advance ;-)

Glenn
已提问 5 个月前1313 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则