sap_restricted_table_read_via_table_browser
Description
A dialog user read a restricted table through a generic table browser transaction
Query · yara_l
events:
$e.metadata.log_type = "SAP_SECURITY_AUDIT"
$e.additional.fields["msg_1"] = "DU9"
$e.security_result.detection_fields["slgtc_1"] = /^(SE11|SE16|SE16N)$/ nocase
$system = $e.target.application
$user = $e.principal.user.userid
$table = $e.additional.fields["param1_1"]
$table in %sap_sensitive_tables.name
//not $user in %sap_excluded_users.userid
match:
$user, $table, $system over 2h
outcome:
$risk_score = 65
$event_count = count($e.metadata.id)
$activity_code = array_distinct($e.additional.fields["param2_1"])
$client_ids = array_distinct($e.target.resource.attribute.labels["slgmand_1"])
$source_ips = array_distinct($e.principal.ip)
$terminal_names = array_distinct($e.principal.hostname)
$abap_programs = array_distinct($e.principal.process.file.names)
$transaction_codes = array_distinct($e.security_result.detection_fields["slgtc_1"])
$audit_class = array_distinct($e.security_result.summary)
$event_description = array_distinct($e.metadata.description)
condition:
$e