3.15 Ensure access to 'sp_invoke_external_rest_endpoint' is limited to trusted accounts only

Information

Limit the access to the invocation of the sp_invoke_external_rest_endpoint stored procedure.

Using the sp_invoke_external_rest_endpoint stored procedure allows for the transfer of data to an external entity.

NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.

Solution

Remove any un-allowed accounts which are granted the privilege to execute the stored procedure by using this query:

REVOKE EXECUTE ON OBJECT::sys.sp_invoke_external_rest_endpoint FROM [%accountName%];

See Also

https://workbench.cisecurity.org/benchmarks/25734