mirror of
https://github.com/splunk/security_content
synced 2026-06-08 17:32:49 +00:00
Eric
85 lines
4.3 KiB
YAML
85 lines
4.3 KiB
YAML
name: Linux Sqlite3 Privilege Escalation
|
|
id: ab75dbb7-c3ba-4689-9c1b-8d2717bdcba1
|
|
version: 9
|
|
date: '2025-05-02'
|
|
author: Gowthamaraj Rajendran, Splunk
|
|
status: production
|
|
type: Anomaly
|
|
description: The following analytic detects the execution of the sqlite3 command with
|
|
elevated privileges, which can be exploited for privilege escalation. It leverages
|
|
Endpoint Detection and Response (EDR) telemetry to identify instances where sqlite3
|
|
is used in conjunction with shell commands and sudo. This activity is significant
|
|
because it indicates a potential attempt to gain root access, which could lead to
|
|
full system compromise. If confirmed malicious, an attacker could execute arbitrary
|
|
commands as root, leading to unauthorized access, data exfiltration, or further
|
|
lateral movement within the network.
|
|
data_source:
|
|
- Sysmon for Linux EventID 1
|
|
search: '| tstats `security_content_summariesonly` count min(_time) as firstTime max(_time)
|
|
as lastTime from datamodel=Endpoint.Processes where Processes.process="*sqlite3*"
|
|
AND Processes.process="*.shell*" AND Processes.process="*sudo*" by Processes.action
|
|
Processes.dest Processes.original_file_name Processes.parent_process Processes.parent_process_exec
|
|
Processes.parent_process_guid Processes.parent_process_id Processes.parent_process_name
|
|
Processes.parent_process_path Processes.process Processes.process_exec Processes.process_guid
|
|
Processes.process_hash Processes.process_id Processes.process_integrity_level Processes.process_name
|
|
Processes.process_path Processes.user Processes.user_id Processes.vendor_product
|
|
| `drop_dm_object_name(Processes)` | `security_content_ctime(firstTime)` | `security_content_ctime(lastTime)`
|
|
| `linux_sqlite3_privilege_escalation_filter`'
|
|
how_to_implement: The detection is based on data that originates from Endpoint Detection
|
|
and Response (EDR) agents. These agents are designed to provide security-related
|
|
telemetry from the endpoints where the agent is installed. To implement this search,
|
|
you must ingest logs that contain the process GUID, process name, and parent process.
|
|
Additionally, you must ingest complete command-line executions. These logs must
|
|
be processed using the appropriate Splunk Technology Add-ons that are specific to
|
|
the EDR product. The logs must also be mapped to the `Processes` node of the `Endpoint`
|
|
data model. Use the Splunk Common Information Model (CIM) to normalize the field
|
|
names and speed up the data modeling process.
|
|
known_false_positives: False positives may be present, filter as needed.
|
|
references:
|
|
- https://gtfobins.github.io/gtfobins/sqlite3/
|
|
- https://manpages.ubuntu.com/manpages/trusty/en/man1/sqlite3.1.html
|
|
drilldown_searches:
|
|
- name: View the detection results for - "$dest$"
|
|
search: '%original_detection_search% | search dest = "$dest$"'
|
|
earliest_offset: $info_min_time$
|
|
latest_offset: $info_max_time$
|
|
- name: View risk events for the last 7 days for - "$dest$"
|
|
search: '| from datamodel Risk.All_Risk | search normalized_risk_object IN ("$dest$")
|
|
starthoursago=168 | stats count min(_time) as firstTime max(_time) as lastTime
|
|
values(search_name) as "Search Name" values(risk_message) as "Risk Message" values(analyticstories)
|
|
as "Analytic Stories" values(annotations._all) as "Annotations" values(annotations.mitre_attack.mitre_tactic)
|
|
as "ATT&CK Tactics" by normalized_risk_object | `security_content_ctime(firstTime)`
|
|
| `security_content_ctime(lastTime)`'
|
|
earliest_offset: $info_min_time$
|
|
latest_offset: $info_max_time$
|
|
rba:
|
|
message: An instance of $parent_process_name$ spawning $process_name$ was identified
|
|
on endpoint $dest$
|
|
risk_objects:
|
|
- field: dest
|
|
type: system
|
|
score: 30
|
|
threat_objects:
|
|
- field: parent_process_name
|
|
type: parent_process_name
|
|
- field: process_name
|
|
type: process_name
|
|
tags:
|
|
analytic_story:
|
|
- Linux Privilege Escalation
|
|
- Linux Living Off The Land
|
|
asset_type: Endpoint
|
|
mitre_attack_id:
|
|
- T1548.003
|
|
product:
|
|
- Splunk Enterprise
|
|
- Splunk Enterprise Security
|
|
- Splunk Cloud
|
|
security_domain: endpoint
|
|
tests:
|
|
- name: True Positive Test
|
|
attack_data:
|
|
- data: https://media.githubusercontent.com/media/splunk/attack_data/master/datasets/attack_techniques/T1548/sqlite3/sysmon_linux.log
|
|
source: Syslog:Linux-Sysmon/Operational
|
|
sourcetype: sysmon:linux
|