detection.wiki

Detection rules › Sigma

SQLite Firefox Profile Data DB Access

Status
test
Severity
high
Log source
product windows, category process_creation
Author
frack113
Source
github.com/SigmaHQ/sigma

Detect usage of the "sqlite" binary to query databases in Firefox and other Gecko-based browsers for potential data stealing.

MITRE ATT&CK coverage

TacticTechniques
Credential AccessT1539 Steal Web Session Cookie
CollectionT1005 Data from Local System

Event coverage

ProviderEventTitle
SysmonEvent ID 1Process creation

Rule body yaml

title: SQLite Firefox Profile Data DB Access
id: 4833155a-4053-4c9c-a997-777fcea0baa7
status: test
description: Detect usage of the "sqlite" binary to query databases in Firefox and other Gecko-based browsers for potential data stealing.
references:
    - https://github.com/redcanaryco/atomic-red-team/blob/f339e7da7d05f6057fdfcdd3742bfcf365fee2a9/atomics/T1539/T1539.md#atomic-test-1---steal-firefox-cookies-windows
    - https://blog.cyble.com/2022/04/21/prynt-stealer-a-new-info-stealer-performing-clipper-and-keylogger-activities/
author: frack113
date: 2022-04-08
modified: 2023-01-19
tags:
    - attack.credential-access
    - attack.t1539
    - attack.collection
    - attack.t1005
logsource:
    category: process_creation
    product: windows
detection:
    selection_sql:
        - Product: SQLite
        - Image|endswith:
              - '\sqlite.exe'
              - '\sqlite3.exe'
    selection_firefox:
        CommandLine|contains:
            - 'cookies.sqlite'
            - 'places.sqlite' # Bookmarks, history
    condition: all of selection_*
falsepositives:
    - Unknown
level: high

Stages and Predicates

Stage 0: condition

all of selection_*

Stage 1: selection_sql

selection_sql:
    - Product: SQLite
    - Image|endswith:
          - '\sqlite.exe'
          - '\sqlite3.exe'

Stage 2: selection_firefox

selection_firefox:
    CommandLine|contains:
        - 'cookies.sqlite'
        - 'places.sqlite'

Indicators

Each row is a field, operator, and value that the rule matches. The corpus column counts how many other rules in the catalog look for the same combination: high numbers point to widely-used, community-vetted indicators. Blank or 1 shows that the indicator is specific to this rule.

FieldKindValues
CommandLinematch
  • cookies.sqlite corpus 3 (sigma 2, panther 1)
  • places.sqlite corpus 2 (sigma 2)
Imageends_with
  • \sqlite.exe corpus 2 (sigma 2)
  • \sqlite3.exe corpus 2 (sigma 2)
Producteq
  • SQLite corpus 2 (sigma 2)