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

entityMappings:
- fieldMappings:
  - identifier: Name
    columnName: FileCustomEntity
  entityType: File
- fieldMappings:
  - identifier: Url
    columnName: UrlCustomEntity
  entityType: URL
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicRequestToSensitiveFiles.yaml
queryFrequency: 15m
triggerOperator: gt
queryPeriod: 15m
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  
relevantTechniques:
- T1189
version: 1.0.3
tactics:
- InitialAccess
severity: High
name: Oracle - Request to sensitive files
requiredDataConnectors:
- dataTypes:
  - OracleWebLogicServer_CL
  connectorId: CustomLogsAma
triggerThreshold: 0
kind: Scheduled
status: Available
description: |
    'Detects request to sensitive files.'
id: 9cc9ed36-573f-11ec-bf63-0242ac130002

ARM