Detection rules › YARA-L

sap sensitive tables direct access by rfc logon data table

Severity
high
Time window
1h
Match by
table
Author
Google Cloud Security
Source
github.com/chronicle/detection-rules

Detects direct access to sensitive SAP tables (e.g., USR02, T000) specifically via RFC logon. This identifies potential data exfiltration or unauthorized inspection of security-critical data tables.

MITRE ATT&CK coverage

TacticTechniques
CollectionT1005 Data from Local System

Rule body yaral

/*
 * Copyright 2026 Google LLC
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

rule sap_sensitive_tables_direct_access_by_rfc_logon_data_table {

  meta:
    author = "Google Cloud Security"
    description = "Detects direct access to sensitive SAP tables (e.g., USR02, T000) specifically via RFC logon. This identifies potential data exfiltration or unauthorized inspection of security-critical data tables."
    severity = "High"
    tactic = "TA0009"
    technique = "T1005"

  events:
    $e.metadata.log_type = "SAP_SECURITY_AUDIT"
    $e.additional.fields["msg_1"] = "CUZ"
    $SID = $e.target.application
    $table = $e.additional.fields["param1_1"]

    $table in %sap_sensitive_tables.name

  match:
    $table over 1h

  outcome:
    $user_list = array_distinct($e.principal.user.userid)
    $source_ips = array_distinct($e.principal.ip)
    $system_ids = array_distinct($SID)
    $event_count = count($e.metadata.id)
    $terminal_names = array_distinct($e.principal.hostname)

  condition:
    $e
}

Detection logic

Fires when at least one $e event in the 1h window.

Events

$e

  • metadata.log_type = "SAP_SECURITY_AUDIT"
  • additional.fields["msg_1"] = "CUZ"
  • additional.fields["param1_1"] in "%sap_sensitive_tables.name"

Correlation

Match key
$table
Within
1h

Outcome

Fields the detection emits on a match. $risk_score drives alerting; Chronicle surfaces the rest on the detection.

FieldExpression
user_listarray_distinct($e.principal.user.userid)
source_ipsarray_distinct($e.principal.ip)
system_idsarray_distinct($SID)
event_countcount($e.metadata.id)
terminal_namesarray_distinct($e.principal.hostname)