Detection rules › YARA-L
sap sensitive tables direct access by rfc logon data table
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
| Tactic | Techniques |
|---|---|
| Collection | T1005 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
Outcome
Fields the detection emits on a match. $risk_score drives alerting; Chronicle surfaces the rest on the detection.
| Field | Expression |
|---|---|
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) |