Snowflake - Possible privileges discovery activity

Status: available
Severity: medium
Time window: 1h
Source: github.com/Azure/Azure-Sentinel

'Detects possible privileges discovery activity.'

MITRE ATT&CK coverage

Tactic	Techniques
Discovery	`T1087` Account Discovery

Rule body

id: 627a4ff1-036b-4375-a9f9-288d5e1d7d37
name: Snowflake - Possible privileges discovery activity
description: |
  'Detects possible privileges discovery activity.'
severity: Medium
status: Available
requiredDataConnectors:
  - connectorId: Snowflake
    dataTypes:
      - Snowflake
queryFrequency: 1h
queryPeriod: 1h
triggerOperator: gt
triggerThreshold: 0
tactics:
  - Discovery
relevantTechniques:
  - T1087
query: |
  Snowflake
  | where QueryType =~ 'SHOW'
  | where QueryText has_all ('SHOW', 'ROLES')
  | extend AccountCustomEntity = TargetUsername
entityMappings:
  - entityType: Account
    fieldMappings:
      - identifier: Name
        columnName: AccountCustomEntity
version: 1.0.1
kind: Scheduled

Stages and Predicates

Stage 1: `source`

Snowflake

Stage 2: `where`

| where QueryType =~ 'SHOW'

Stage 3: `where`

| where QueryText has_all ('SHOW', 'ROLES')

Stage 4: `extend`

| extend AccountCustomEntity = TargetUsername

Indicators

These rows show field, operator, and value matches.

Field	Kind	Values	Search
`QueryText`	match	`ROLES` transforms: `term` `SHOW` transforms: `term`	`field:"QueryText" kind:match`
`QueryType`	eq	`SHOW`	`field:"QueryType" kind:eq value:"SHOW"`

Output fields

These fields are emitted when the rule matches.

Field	Source
`AccountCustomEntity`	`extend`

Snowflake - Possible privileges discovery activity

MITRE ATT&CK coverage

Rule body

Stages and Predicates

Stage 1: source

Stage 2: where

Stage 3: where

Stage 4: extend

Indicators

Output fields

Stage 1: `source`

Stage 2: `where`

Stage 3: `where`

Stage 4: `extend`