SQL Server – Ole Automation Procedures – Security

We have a task for request API in JSON and one option is to use Ole Automation Procedures, but I don’t know if it’s safe to enabled this option in SQL Server 2016.

This process will be run automatically with SQL Agent, but I have doubts if this will compromise SQL Server security.

Here is an example:

Example

Leave a Comment