Account Added to Sysadmin Role in MSSQL
Last updated on:
In this page
About the rule
Rule Type
Standard
Rule Description
Detects instances where an attacker tries to create a backdoor to the MSSQL server by adding anaccount to the Sysadmin role, which is the highest-level fixed server role.
Severity
Trouble
Rule Requirement
Criteria
Action1: actionname = "sa_sql_operation" AND (OBJECTNAME contains "sysadmin" AND STATEMENT contains "alter server role [sysadmin] add member ") 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)
