Oracle - Request to sensitive files

Back


Id	9cc9ed36-573f-11ec-bf63-0242ac130002
Rulename	Oracle - Request to sensitive files
Description	Detects request to sensitive files.
Severity	High
Tactics	InitialAccess
Techniques	T1189
Required data connectors	CustomLogsAma
Kind	Scheduled
Query frequency	15m
Query period	15m
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicRequestToSensitiveFiles.yaml
Version	1.0.3
Arm template	9cc9ed36-573f-11ec-bf63-0242ac130002.json

KQL

let forbidden_files = dynamic(['shadow', 'passwd', 'hosts', 'id_rsa']);
OracleWebLogicServerEvent    
| extend File = extract(@'(.*\/)?(.*)', 2, tostring(UrlOriginal))
| where isnotempty(File)
| where File in~ (forbidden_files)
| extend FileCustomEntity = File, UrlCustomEntity = UrlOriginal

YAML

description: |
    'Detects request to sensitive files.'
version: 1.0.3
triggerThreshold: 0
tactics:
- InitialAccess
queryPeriod: 15m
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicRequestToSensitiveFiles.yaml
triggerOperator: gt
status: Available
id: 9cc9ed36-573f-11ec-bf63-0242ac130002
name: Oracle - Request to sensitive files
queryFrequency: 15m
severity: High
kind: Scheduled
entityMappings:
- fieldMappings:
  - columnName: FileCustomEntity
    identifier: Name
  entityType: File
- fieldMappings:
  - columnName: UrlCustomEntity
    identifier: Url
  entityType: URL
relevantTechniques:
- T1189
query: |
  let forbidden_files = dynamic(['shadow', 'passwd', 'hosts', 'id_rsa']);
  OracleWebLogicServerEvent    
  | extend File = extract(@'(.*\/)?(.*)', 2, tostring(UrlOriginal))
  | where isnotempty(File)
  | where File in~ (forbidden_files)
  | extend FileCustomEntity = File, UrlCustomEntity = UrlOriginal  
requiredDataConnectors:
- dataTypes:
  - OracleWebLogicServer_CL
  connectorId: CustomLogsAma

ARM