AWS RDS Automated Backup Deleted


Description

Detects deletion of RDS automated backups. This is a classic ransomware tactic where attackers delete automated backups before encrypting or destroying databases to prevent recovery. Any automated backup deletion should be investigated immediately.

Query · python

from panther_aws_helpers import aws_rule_context


def rule(event):
    if event.get("eventSource") != "rds.amazonaws.com":
        return False
    deletion_events = ["DeleteDBInstanceAutomatedBackup", "DeleteDBClusterAutomatedBackup"]
    if event.get("eventName") not in deletion_events:
        return False
    return event.deep_get("errorCode") is None


def title(event):
    event_name = event.get("eventName", "Unknown")
    backup_arn = event.deep_get("requestParameters", "dbiResourceId") or event.deep_get(
        "requestParameters", "dbClusterResourceId", default="<UNKNOWN>"
    )
    user = event.deep_get("userIdentity", "userName") or event.deep_get(
        "userIdentity", "principalId", default="<UNKNOWN_USER>"
    )
    resource_type = (
        "Automated Backup" if event_name == "DeleteDBInstanceAutomatedBackup" else "Cluster Backup"
    )
    return f"RDS {resource_type} Deleted: [{backup_arn}] by [{user}]"


def dedup(event):
    backup_id = event.deep_get("requestParameters", "dbiResourceId") or event.deep_get(
        "requestParameters", "dbClusterResourceId", default="unknown"
    )
    account_id = event.deep_get("recipientAccountId", default="unknown")
    region = event.get("awsRegion", "unknown")
    return f"{account_id}:{region}:{backup_id}"


def alert_context(event):
    context = aws_rule_context(event)
    context["dbi_resource_id"] = event.deep_get("requestParameters", "dbiResourceId", default="N/A")
    context["db_cluster_resource_id"] = event.deep_get(
        "requestParameters", "dbClusterResourceId", default="N/A"
    )
    context["backup_arn"] = event.deep_get(
        "responseElements", "dBInstanceAutomatedBackupArn"
    ) or event.deep_get("responseElements", "dBClusterAutomatedBackupArn", default="N/A")
    return context

Analyst notes

  1. Find all automated backup deletion events by the user ARN in the past 24 hours to identify bulk deletion patterns
  2. Check if this user has deleted automated backups in the past 90 days to determine if this is normal behavior
  3. Look for database deletion or modification events from this user in the 6 hours after this backup deletion
Raw source AWS RDS Automated Backup Deleted · Panther Python
Esc
Published by panther-labs/panther-analysis ↗, licensed under Apache 2.0 ↗. Reproduced here unmodified.
AnalysisType: rule
Filename: aws_rds_automated_backup_deleted.py
RuleID: "AWS.RDS.AutomatedBackupDeleted"
DisplayName: "AWS RDS Automated Backup Deleted"
Enabled: true
LogTypes:
  - AWS.CloudTrail
Tags:
  - AWS
  - Impact
  - Defense Evasion
  - Data Destruction
  - Inhibit System Recovery
  - Ransomware
  - RDS
Severity: Critical
Description: >
  Detects deletion of RDS automated backups. This is a classic ransomware tactic where
  attackers delete automated backups before encrypting or destroying databases to prevent
  recovery. Any automated backup deletion should be investigated immediately.
Runbook: |
  1. Find all automated backup deletion events by the user ARN in the past 24 hours to identify bulk deletion patterns
  2. Check if this user has deleted automated backups in the past 90 days to determine if this is normal behavior
  3. Look for database deletion or modification events from this user in the 6 hours after this backup deletion
Reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithAutomatedBackups.html
Reports:
  MITRE ATT&CK:
    - TA0040:T1485  # Data Destruction
    - TA0040:T1490  # Inhibit System Recovery
DedupPeriodMinutes: 60
SummaryAttributes:
  - eventName
  - userIdentity:principalId
  - requestParameters:dbiResourceId
  - requestParameters:dbClusterResourceId
  - p_any_aws_account_ids
Threshold: 1
Tests:
  - Name: Automated Backup Deleted
    ExpectedResult: true
    Log:
      eventVersion: "1.08"
      userIdentity:
        type: AssumedRole
        principalId: "AIDAI23HXS3EXAMPLE:attacker"
        arn: "arn:aws:sts::123456789012:assumed-role/CompromisedRole/attacker"
        accountId: "123456789012"
        accessKeyId: "ASIAIOSFODNN7EXAMPLE"
      eventTime: "2024-01-16T10:00:00Z"
      eventSource: rds.amazonaws.com
      eventName: DeleteDBInstanceAutomatedBackup
      awsRegion: us-east-1
      sourceIPAddress: "185.220.101.50"
      userAgent: "python-requests/2.28.0"
      requestParameters:
        dbiResourceId: "db-ABCDEF1234567890"
      responseElements:
        dBInstanceAutomatedBackupArn: "arn:aws:rds:us-east-1:123456789012:auto-backup:ab-1234567890abcdef"
        dbiResourceId: "db-ABCDEF1234567890"
        status: "deleting"
        allocatedStorage: 100
        engine: "mysql"
        engineVersion: "8.0.35"
      requestID: "a1b2c3d4-e5f6-7890-abcd-ef1234567890"
      eventID: "f1e2d3c4-b5a6-7890-1234-567890abcdef"
      readOnly: false
      eventType: AwsApiCall
      managementEvent: true
      recipientAccountId: "123456789012"
      eventCategory: Management

  - Name: Cluster Automated Backup Deleted
    ExpectedResult: true
    Log:
      eventVersion: "1.08"
      userIdentity:
        type: IAMUser
        principalId: "AIDAI23HXS3EXAMPLE"
        arn: "arn:aws:iam::123456789012:user/malicious-user"
        accountId: "123456789012"
        accessKeyId: "AKIAIOSFODNN7EXAMPLE"
        userName: malicious-user
      eventTime: "2024-01-16T10:00:00Z"
      eventSource: rds.amazonaws.com
      eventName: DeleteDBClusterAutomatedBackup
      awsRegion: us-west-2
      sourceIPAddress: "198.51.100.200"
      userAgent: "aws-cli/2.13.0"
      requestParameters:
        dbClusterResourceId: "cluster-GHIJKL9876543210"
      responseElements:
        dBClusterAutomatedBackupArn: "arn:aws:rds:us-west-2:123456789012:cluster-auto-backup:cab-9876543210fedcba"
        dbClusterResourceId: "cluster-GHIJKL9876543210"
        status: "deleting"
        engine: "aurora-mysql"
        engineVersion: "8.0.mysql_aurora.3.04.0"
      requestID: "b2c3d4e5-f6a7-8901-bcde-f1234567890a"
      eventID: "g2f3e4d5-c6b7-8901-2345-678901bcdefg"
      readOnly: false
      eventType: AwsApiCall
      managementEvent: true
      recipientAccountId: "123456789012"
      eventCategory: Management

  - Name: Automated Backup Deletion Failed
    ExpectedResult: false
    Log:
      eventVersion: "1.08"
      userIdentity:
        type: IAMUser
        principalId: "AIDAI23HXS3EXAMPLE"
        arn: "arn:aws:iam::123456789012:user/developer"
        accountId: "123456789012"
        accessKeyId: "AKIAIOSFODNN7EXAMPLE"
        userName: developer
      eventTime: "2024-01-16T10:00:00Z"
      eventSource: rds.amazonaws.com
      eventName: DeleteDBInstanceAutomatedBackup
      awsRegion: us-east-1
      sourceIPAddress: "10.0.1.100"
      userAgent: "aws-cli/2.13.0"
      requestParameters:
        dbiResourceId: "db-ABCDEF1234567890"
      errorCode: AccessDenied
      errorMessage: "User is not authorized to perform: rds:DeleteDBInstanceAutomatedBackup"
      requestID: "c3d4e5f6-a7b8-9012-cdef-1234567890ab"
      eventID: "h3g4f5e6-d7c8-9012-3456-789012cdefgh"
      readOnly: false
      eventType: AwsApiCall
      managementEvent: true
      recipientAccountId: "123456789012"
      eventCategory: Management

  - Name: Different RDS Event
    ExpectedResult: false
    Log:
      eventVersion: "1.08"
      userIdentity:
        type: AssumedRole
        principalId: "AIDAI23HXS3EXAMPLE:user"
        arn: "arn:aws:sts::123456789012:assumed-role/Admin/user"
        accountId: "123456789012"
      eventTime: "2024-01-16T10:00:00Z"
      eventSource: rds.amazonaws.com
      eventName: CreateDBInstanceReadReplica
      awsRegion: us-east-1
      sourceIPAddress: "10.0.1.100"
      requestParameters:
        dBInstanceIdentifier: "replica-instance"
        sourceDBInstanceIdentifier: "primary-instance"
      requestID: "d4e5f6a7-b8c9-0123-def0-1234567890bc"
      eventID: "i4h5g6f7-e8d9-0123-4567-890123defghi"
      readOnly: false
      eventType: AwsApiCall
      managementEvent: true
      recipientAccountId: "123456789012"
      eventCategory: Management


# ------ paired body: aws_rds_automated_backup_deleted.py ------

from panther_aws_helpers import aws_rule_context


def rule(event):
    if event.get("eventSource") != "rds.amazonaws.com":
        return False
    deletion_events = ["DeleteDBInstanceAutomatedBackup", "DeleteDBClusterAutomatedBackup"]
    if event.get("eventName") not in deletion_events:
        return False
    return event.deep_get("errorCode") is None


def title(event):
    event_name = event.get("eventName", "Unknown")
    backup_arn = event.deep_get("requestParameters", "dbiResourceId") or event.deep_get(
        "requestParameters", "dbClusterResourceId", default="<UNKNOWN>"
    )
    user = event.deep_get("userIdentity", "userName") or event.deep_get(
        "userIdentity", "principalId", default="<UNKNOWN_USER>"
    )
    resource_type = (
        "Automated Backup" if event_name == "DeleteDBInstanceAutomatedBackup" else "Cluster Backup"
    )
    return f"RDS {resource_type} Deleted: [{backup_arn}] by [{user}]"


def dedup(event):
    backup_id = event.deep_get("requestParameters", "dbiResourceId") or event.deep_get(
        "requestParameters", "dbClusterResourceId", default="unknown"
    )
    account_id = event.deep_get("recipientAccountId", default="unknown")
    region = event.get("awsRegion", "unknown")
    return f"{account_id}:{region}:{backup_id}"


def alert_context(event):
    context = aws_rule_context(event)
    context["dbi_resource_id"] = event.deep_get("requestParameters", "dbiResourceId", default="N/A")
    context["db_cluster_resource_id"] = event.deep_get(
        "requestParameters", "dbClusterResourceId", default="N/A"
    )
    context["backup_arn"] = event.deep_get(
        "responseElements", "dBInstanceAutomatedBackupArn"
    ) or event.deep_get("responseElements", "dBClusterAutomatedBackupArn", default="N/A")
    return context

Detection rules belong to the projects that publish them and remain under their own licenses. This site indexes and links to them; it claims no rights in them.