↳ GitHub sourceAnalytics ruleMedium

OracleDBAudit - Unusual user activity on multiple tables

Description

'Detects when user queries many tables in short period of time.'
Rule type
Scheduled
Version
1.0.2
Declared status
Available
Query frequency
1h
Query period
1h
Trigger
gt 0

Declared MITRE coverage

Declared sources

Metadata from the source file. No dependencies inferred from KQL.

Connectors

KQL query

Original query, unchanged.

let tbl_threshold = 10;
OracleDatabaseAuditEvent
| where isnotempty(DstUserName)
| where DbAction =~ 'SELECT'
| extend TableName = replace(@'[,\(\)]', '', extract(@'(?i)SELECT(.*?)FROM\s(.*?)\s', 2, Action))
| where isnotempty(TableName)
| where TableName !~ 'SELECT'
| summarize tbl_count = dcount(TableName) by DstUserName, bucket = bin(TimeGenerated, 5m)
| where tbl_count > tbl_threshold
| extend AccountCustomEntity = DstUserName

Declared entities

Account

Related content

Links established from declared identifiers and solution manifests.

Source provenance

GitHub

Displayed values come from files in Azure/Azure-Sentinel. They describe the published template, not your workspace configuration.

Source identifier
75024e1c-26e7-4e73-821d-95e5decdd8db
Additional source files 2Solutions/OracleDatabaseAudit/Analytic Rules/OracleDBAuditSelectOnManyTables.yamlsource ↗Solutions/OracleDatabaseAudit/Data/Solution_OracleDBAudit.jsonsolution-membership ↗
GSTEP / CATALOG TRACKING

Added to catalog : 16 Sept 2026 · 05:49 UTC
Last change observed : 16 Sept 2026 · 05:49 UTC

GSTEP sync dates, separate from the source content’s publication dates.