Detections
Analytics

SQLD-22-002600 - SQL Server must associate organization-defined types of security labels having organization-defined security label values with information in process, transit, or storage.

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

Without the association of security labels to information, there is no basis for SQL Server to make security-related access-control decisions.

Security labels are abstractions representing the basic properties or characteristics of an entity (e.g., subjects and objects) with respect to safeguarding information.

These labels are typically associated with internal data structures (e.g., tables, rows) within the database and are used to enable the implementation of access control and flow control policies; reflect special dissemination, handling, or distribution instructions; or support other aspects of the information security policy.

One example includes marking data as classified or CUI. These security labels may be assigned manually or during data processing, but, either way, it is imperative these assignments are maintained while the data is in storage. If the security labels are lost when the data is stored, there is the risk of a data compromise.

The mechanism used to support security labeling may be a feature of SQL Server, a third-party product, or custom application code.

Satisfies: SRG-APP-000311-DB-000308, SRG-APP-000314-DB-000310

NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.

Solution

Deploy SQL Server Row-Level Security (refer to link below) or a third-party software, or add custom data structures, data elements, and application code, to provide reliable security labeling of information.

https://msdn.microsoft.com/en-us/library/dn765131.aspx

See Also

https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_MS_SQL_Server_2022_Y26M01_STIG.zip

Item Details

References: CAT|II, CCI|CCI-002262, CCI|CCI-002263, CCI|CCI-002264, Rule-ID|SV-271184r1138541_rule, STIG-ID|SQLD-22-002600, Vuln-ID|V-271184

Plugin: MS_SQLDB

Control ID: 51c8ea98c7325c13dc99ce92231aa90deb30b976dbef5175d29c230e9d77fa9e