Theom - Overprovisioned Roles Shadow DB

Back


Id	fb7769d0-e622-4479-95b4-f6266a5b41e2
Rulename	Theom - Overprovisioned Roles Shadow DB
Description	“Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0034 (Theom has observed shadow (or clone) databases/tables. Additionally, it has observed roles that are overprovisioned for 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/TRIS0034_Overprovisioned_Roles_Shadow_DB.yaml
Version	1.0.2
Arm template	fb7769d0-e622-4479-95b4-f6266a5b41e2.json

KQL

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

YAML

name: Theom - Overprovisioned Roles Shadow DB
query: |
  TheomAlerts_CL
    | where customProps_RuleId_s == "TRIS0034" and (priority_s == "P1" or priority_s == "P2")  
entityMappings:
- entityType: CloudApplication
  fieldMappings:
  - columnName: customProps_AssetName_s
    identifier: Name
- entityType: URL
  fieldMappings:
  - columnName: deepLink_s
    identifier: Url
queryPeriod: 5m
version: 1.0.2
tactics:
- Collection
- PrivilegeEscalation
triggerOperator: gt
kind: Scheduled
triggerThreshold: 0
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Theom/Analytic Rules/TRIS0034_Overprovisioned_Roles_Shadow_DB.yaml
eventGroupingSettings:
  aggregationKind: AlertPerResult
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}} '
relevantTechniques:
- T1560
- T1530
- T1078
id: fb7769d0-e622-4479-95b4-f6266a5b41e2
severity: High
requiredDataConnectors:
- connectorId: Theom
  dataTypes:
  - TheomAlerts_CL
status: Available
description: |
    "Creates Sentinel incidents for critical/high Theom risks, associated with ruleId TRIS0034 (Theom has observed shadow (or clone) databases/tables. Additionally, it has observed roles that are overprovisioned for these data stores. As per this requirement, use this information to apply data access control lists or access permissions and enforce data retention policies)"
queryFrequency: 5m

ARM