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
preguntada hace 5 meses1313 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas