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

Question

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 ;-)

Giovanni Lauria · Answer

You can grant the EXECUTE permission directly on the sp_OACreate procedure in the master database where it resides.

```
USE master;
GRANT EXECUTE ON sp_OACreate TO ;
```
If login and user are orphaned (No link between them) you can recreate it with

```
ALTER USER  WITH LOGIN = ;

```

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

Add your answer

Relevant content