MSSQL SPProcoption Set
Last updated on:
In this page
About the rule
Rule Type
Standard
Rule Description
Detects instances where a stored procedure option is set or cleared for automatic execution in MSSQL. A stored procedure that is set to automatically execute runs every time the SQL Server is started.
Severity
Trouble
Rule Requirement
Criteria
Action1: actionname = "sa_sql_operation" AND (OBJECTNAME contains "sp_procoption" AND STATEMENT contains "EXEC") select Action1.USERNAME,Action1.MESSAGE,Action1.DOMAIN,Action1.HOSTNAME,Action1.STATEMENT,Action1.OBJECTNAME,Action1.SCHEMANAME,Action1.DATABASENAME,Action1.INSTANCENAME
Detection
Execution Mode
Realtime
Log Sources
SQL Server
Author
Nasreddine Bencherchali (Nextron Systems)
