Executes a stored procedure because it uses some
--Creating ObjectsEXECsp_OACreate'VBScript.RegExp',@objRegex out--Setting PropertiesEXECsp_OASetProperty@objRegex,'Pattern',@pattern EXECsp_OASetProperty@objRegex,'IgnoreCase',@IgnoreCase EXECsp_OASetProperty@objRegex,'Global',1 --ExecutionEXECsp_OAMethod@objRegex,'Replace',@retstrOut,@string,@replacestr --ReleaseEXECUTEsp_OADestroy@objRegex
Prompt after execution:
Error getting result set exec C_news_main_2_p_news_main 18760037
1310|159|c_news_main_2_p_news_main|18760037|-1|2017-7-10 18:41:03|0|0|0
Message seq:18760037
Message: 1310|159|c_news_main_2_p_news_main|18760037|-1|2017-7-10 18:41:03|0|0|0
The EXECUTE permission on the object ' sp_OACreate ' (Database ' Mssqlsystemresource ', schema ' sys ') was rejected.
The EXECUTE permission on the object ' sp_OACreate ' (Database ' Mssqlsystemresource ', schema ' sys ') was rejected.
Processing method:
Grant Execute on to Etler
Other stored procedures the same way to permissions
The EXECUTE permission on the object ' sp_OACreate ' (Database ' Mssqlsystemresource ', schema ' sys ') was rejected.