界: API Abuse

API 是调用方和被调用方之间的约定。最常见的 API 滥用是由于调用方未能遵守此约定的终止导致的。例如，如果某个程序在调用 chroot() 后未能调用 chdir()，则违反了用于指定如何安全地更改活动根目录的约定。库滥用的另一个典型示例是期望被调用方向调用方返回可信的 DNS 信息。在这种情况下，调用方通过对被调用方行为做出某种假设（返回值可用于身份验证目的）滥用其 API。另一方也可能违反调用方-被调用方约定。例如，如果编码器子类化 SecureRandom 并返回一个非随机值，则将违反此约定。

Dangerous Function: xp_cmdshell

PLSQL/TSQL

Abstract

无法安全地使用函数 xp_cmdshell。不应该使用此函数。

Explanation

某些函数不论如何使用都有危险性。函数 xp_cmdshell 会启动 Windows 命令 shell 来执行提供的命令字符串。该命令会在默认系统中或提供的代理上下文中执行。但目前没有一种方法可将用户限制为只能执行一组预先指定的特权操作，为用户授予任何权限都会允许其执行任何命令字符串。

References

[1] xp_cmdshell

[2] Standards Mapping - CIS Azure Kubernetes Service Benchmark 4

[3] Standards Mapping - CIS Microsoft Azure Foundations Benchmark partial

[4] Standards Mapping - CIS Amazon Elastic Kubernetes Service Benchmark 4

[5] Standards Mapping - CIS Amazon Web Services Foundations Benchmark 4

[6] Standards Mapping - CIS Google Kubernetes Engine Benchmark integrity

[7] Standards Mapping - Common Weakness Enumeration CWE ID 242

[8] Standards Mapping - General Data Protection Regulation (GDPR) Indirect Access to Sensitive Data

[9] Standards Mapping - OWASP Mobile 2014 M7 Client Side Injection

[10] Standards Mapping - Payment Card Industry Data Security Standard Version 3.0 Requirement 7.1.2

[11] Standards Mapping - Payment Card Industry Data Security Standard Version 3.2 Requirement 7.1.2

[12] Standards Mapping - Payment Card Industry Data Security Standard Version 3.2.1 Requirement 7.1.2

[13] Standards Mapping - Payment Card Industry Data Security Standard Version 3.1 Requirement 7.1.2

[14] Standards Mapping - Payment Card Industry Data Security Standard Version 4.0 Requirement 7.2.2

[15] Standards Mapping - Payment Card Industry Software Security Framework 1.0 Control Objective 5.4 - Authentication and Access Control

[16] Standards Mapping - Payment Card Industry Software Security Framework 1.1 Control Objective 5.4 - Authentication and Access Control

[17] Standards Mapping - Payment Card Industry Software Security Framework 1.2 Control Objective 5.4 - Authentication and Access Control

[18] Standards Mapping - SANS Top 25 2011 Risky Resource Management - CWE ID 676

[19] Standards Mapping - Web Application Security Consortium Version 2.00 OS Commanding (WASC-31)

[20] Standards Mapping - Web Application Security Consortium 24 + 2 OS Commanding

desc.semantic.sql.dangerous_function_xp_cmdshell