Detections
Analytics
SQL6-D0-002900 - Execution of stored procedures and functions that utilize execute as must be restricted to necessary cases only.
Information
In certain situations, to provide required functionality, a DBMS needs to execute internal logic (stored procedures, functions, triggers, etc.) and/or external code modules with elevated privileges. However, if the privileges required for execution are at a higher level than the privileges assigned to organizational users invoking the functionality applications/programs, those users are indirectly provided with greater privileges than assigned by organizations.Privilege elevation must be utilized only where necessary and protected from misuse.
NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.
Solution
Alter stored procedures and functions to remove the 'EXECUTE AS' statement.See Also
https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MS_SQL_Server_2016_Y26M01_STIG.zip
Item Details
Audit Name: DISA MS SQL Server 2016 Database STIG v3r4
Category: ACCESS CONTROL
References: 800-53|AC-6(8), CAT|II, CCI|CCI-002233, Rule-ID|SV-213922r1167471_rule, STIG-ID|SQL6-D0-002900, STIG-Legacy|SV-93813, STIG-Legacy|V-79107, Vuln-ID|V-213922
Plugin: MS_SQLDB
Control ID: 50312cb7f37531dc568120a427e3669bb0d31aa5958c24f9126478758d7bba25