Theom - Shadow DB with atypical accesses

Back


Id	02bff937-ca52-4f52-a9cd-b826f8602694
Rulename	Theom - Shadow DB with atypical accesses
Description	“Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0036 (Theom has observed shadow or clone databases/tables. Additionally, it has observed atypical accesses to these data stores. As per this requirement, use this information to apply data access control lists or access permissions and enforce data retention policies)”
Severity	High
Tactics	Collection PrivilegeEscalation
Techniques	T1560 T1530 T1078
Required data connectors	Theom
Kind	Scheduled
Query frequency	5m
Query period	5m
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0036_Shadow_DB_with_atypical_accesses.yaml
Version	1.0.2
Arm template	02bff937-ca52-4f52-a9cd-b826f8602694.json

KQL

TheomAlerts_CL
  | where customProps_RuleId_s == "TRIS0036" and (priority_s == "P1" or priority_s == "P2")

YAML

tactics:
- Collection
- PrivilegeEscalation
triggerOperator: gt
queryPeriod: 5m
queryFrequency: 5m
requiredDataConnectors:
- dataTypes:
  - TheomAlerts_CL
  connectorId: Theom
status: Available
id: 02bff937-ca52-4f52-a9cd-b826f8602694
relevantTechniques:
- T1560
- T1530
- T1078
eventGroupingSettings:
  aggregationKind: AlertPerResult
triggerThreshold: 0
kind: Scheduled
entityMappings:
- fieldMappings:
  - identifier: Name
    columnName: customProps_AssetName_s
  entityType: CloudApplication
- fieldMappings:
  - identifier: Url
    columnName: deepLink_s
  entityType: URL
query: |
  TheomAlerts_CL
    | where customProps_RuleId_s == "TRIS0036" and (priority_s == "P1" or priority_s == "P2")  
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0036_Shadow_DB_with_atypical_accesses.yaml
name: Theom - Shadow DB with atypical accesses
version: 1.0.2
alertDetailsOverride:
  alertDescriptionFormat: |2

    Summary: {{summary_s}}  
    Additional info: {{details_s}}
    Please investigate further on Theom UI at {{deepLink_s}}
  alertDisplayNameFormat: 'Theom Alert ID: {{id_s}} '
severity: High
description: |
    "Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0036 (Theom has observed shadow or clone databases/tables. Additionally, it has observed atypical accesses to these data stores. As per this requirement, use this information to apply data access control lists or access permissions and enforce data retention policies)"

ARM