Pathlock TDnR - SAP HANA Parameter Changes

Back


Id	2a3b4c5d-6e7f-4a0b-8c1d-2e3f4a5b6c29
Rulename	Pathlock TDnR - SAP HANA Parameter Changes
Description	Detects changes to SAP HANA database configuration parameters, forwarded by Pathlock Threat Detection and Response. Unauthorized HANA parameter modifications may be used to disable security controls, weaken audit logging, or alter database behavior to facilitate attacks.
Severity	Medium
Tactics	DefenseEvasion
Techniques	T1562
Required data connectors	Pathlock_TDnR
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Pathlock_TDnR/Analytic Rules/Pathlock_TDnR_HANA_PARAM_CHANGED.yaml
Version	1.0.0
Arm template	2a3b4c5d-6e7f-4a0b-8c1d-2e3f4a5b6c29.json

KQL

Pathlock_TDnR_CL
| where DataSource == "HANA_PARAM_CHANGED"
| project TimeGenerated, Sysid, DataSource, Eventid, Instance, Hostname, Bname,
          Tcode, Report, Area, Subid, SrcIp, DestIp, AffectedUser, LogLine,
          MsgType, MsgId, MsgNo, MessageV1, MessageV2, MessageV3, MessageV4, CentralTs

YAML

entityMappings:
- entityType: Account
  fieldMappings:
  - identifier: Name
    columnName: Bname
- entityType: Host
  fieldMappings:
  - identifier: HostName
    columnName: Hostname
- entityType: IP
  fieldMappings:
  - identifier: Address
    columnName: SrcIp
tactics:
- DefenseEvasion
suppressionEnabled: false
suppressionDuration: 5h
requiredDataConnectors:
- dataTypes:
  - Pathlock_TDnR_CL
  connectorId: Pathlock_TDnR
incidentConfiguration:
  groupingConfiguration:
    reopenClosedIncident: false
    groupByAlertDetails: []
    lookbackDuration: 5h
    groupByEntities: []
    groupByCustomDetails: []
    enabled: true
    matchingMethod: AnyAlert
  createIncident: true
id: 2a3b4c5d-6e7f-4a0b-8c1d-2e3f4a5b6c29
severity: Medium
eventGroupingSettings:
  aggregationKind: SingleAlert
status: Available
query: |
  Pathlock_TDnR_CL
  | where DataSource == "HANA_PARAM_CHANGED"
  | project TimeGenerated, Sysid, DataSource, Eventid, Instance, Hostname, Bname,
            Tcode, Report, Area, Subid, SrcIp, DestIp, AffectedUser, LogLine,
            MsgType, MsgId, MsgNo, MessageV1, MessageV2, MessageV3, MessageV4, CentralTs  
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Pathlock_TDnR/Analytic Rules/Pathlock_TDnR_HANA_PARAM_CHANGED.yaml
kind: Scheduled
queryPeriod: 1h
version: 1.0.0
name: Pathlock TDnR - SAP HANA Parameter Changes
queryFrequency: 1h
triggerThreshold: 0
relevantTechniques:
- T1562
description: Detects changes to SAP HANA database configuration parameters, forwarded by Pathlock Threat Detection and Response. Unauthorized HANA parameter modifications may be used to disable security controls, weaken audit logging, or alter database behavior to facilitate attacks.
triggerOperator: gt

ARM