Microsoft Azure SQL Database Security Technical Implementation Guide
Rules, Groups, and Values defined within the XCCDF Benchmark
-
SRG-APP-000383-DB-000364
<GroupDescription></GroupDescription>Group -
Azure SQL Database must only use approved firewall settings deemed by the organization to be secure, including denying public network access.
<VulnDiscussion>Use of nonsecure firewall settings, such as allowing public access, exposes the system to avoidable threats.</VulnDiscussi...Rule Medium Severity -
SRG-APP-000383-DB-000364
<GroupDescription></GroupDescription>Group -
Azure SQL Database must only use approved firewall settings deemed by the organization to be secure, including denying azure services access to the server.
<VulnDiscussion>Use of nonsecure firewall settings, such as allowing azure services to access the server, exposes the system to avoidable thr...Rule Medium Severity -
SRG-APP-000441-DB-000378
<GroupDescription></GroupDescription>Group -
SRG-APP-000496-DB-000335
<GroupDescription></GroupDescription>Group -
Azure SQL Database must generate audit records when unsuccessful attempts to delete security objects occur.
<VulnDiscussion>The removal of security objects from the database/DBMS would seriously degrade a system's information assurance posture. If s...Rule Medium Severity -
SRG-APP-000502-DB-000348
<GroupDescription></GroupDescription>Group -
SRG-APP-000033-DB-000084
<GroupDescription></GroupDescription>Group -
Azure SQL Database must enforce approved authorizations for logical access to database information and system resources in accordance with applicable access control policies.
<VulnDiscussion>Enterprise environments make account management for applications and databases challenging and complex. A manual process for ...Rule High Severity -
SRG-APP-000033-DB-000084
<GroupDescription></GroupDescription>Group -
Azure SQL Database must enforce approved authorizations for logical access to server information and system resources in accordance with applicable access control policies.
<VulnDiscussion>Authentication with a DOD-approved PKI certificate does not necessarily imply authorization to access Azure SQL Database. To ...Rule High Severity -
SRG-APP-000080-DB-000063
<GroupDescription></GroupDescription>Group -
Azure SQL Database must protect against a user falsely repudiating by ensuring only clearly unique Active Directory user accounts can connect to the database.
<VulnDiscussion>Nonrepudiation of actions taken is required in order to maintain data integrity. Examples of particular actions taken by indi...Rule Medium Severity -
SRG-APP-000080-DB-000063
<GroupDescription></GroupDescription>Group -
Azure SQL Database must protect against a user falsely repudiating by use of system-versioned tables (Temporal Tables).
<VulnDiscussion>Nonrepudiation of actions taken is required in order to maintain data integrity. Examples of particular actions taken by indi...Rule Medium Severity -
SRG-APP-000133-DB-000200
<GroupDescription></GroupDescription>Group -
Database objects (including but not limited to tables, indexes, storage, stored procedures, functions, triggers, links to software external to Azure SQL Database, etc.) must be owned by database/Azure SQL Database principals authorized for ownership.
<VulnDiscussion>Within the database, object ownership implies full privileges to the owned object, including the privilege to assign access t...Rule Medium Severity -
SRG-APP-000133-DB-000362
<GroupDescription></GroupDescription>Group -
The role(s)/group(s) used to modify database structure (including but not necessarily limited to tables, indexes, storage, etc.) and logic modules (stored procedures, functions, triggers, links to software external to Azure SQL Database, etc.) must be restricted to authorized users.
<VulnDiscussion>If the Azure SQL Database were to allow any user to make changes to database structure or logic, then those changes might be ...Rule Medium Severity -
SRG-APP-000233-DB-000124
<GroupDescription></GroupDescription>Group -
The Azure SQL Database must isolate security functions from nonsecurity functions.
<VulnDiscussion>An isolation boundary provides access control and protects the integrity of the hardware, software, and firmware that perform...Rule Medium Severity -
SRG-APP-000243-DB-000128
<GroupDescription></GroupDescription>Group -
Azure SQL Database contents must be protected from unauthorized and unintended information transfer by enforcement of a data-transfer policy.
<VulnDiscussion>Applications, including DBMSs, must prevent unauthorized and unintended information transfer via shared system resources. Da...Rule Medium Severity -
SRG-APP-000251-DB-000160
<GroupDescription></GroupDescription>Group -
Azure SQL Database must check the validity of all data inputs except those specifically identified by the organization.
<VulnDiscussion>Invalid user input occurs when a user inserts data or characters into an application's data entry fields and the application ...Rule Medium Severity -
SRG-APP-000251-DB-000391
<GroupDescription></GroupDescription>Group -
The Azure SQL Database and associated applications must reserve the use of dynamic code execution for situations that require it.
<VulnDiscussion>With respect to database management systems, one class of threat is known as SQL Injection, or more generally, code injection...Rule Medium Severity -
SRG-APP-000251-DB-000392
<GroupDescription></GroupDescription>Group -
The Azure SQL Database and associated applications, when making use of dynamic code execution, must scan input data for invalid values that may indicate a code injection attack.
<VulnDiscussion>With respect to database management systems, one class of threat is known as SQL Injection, or more generally, code injection...Rule Medium Severity -
SRG-APP-000311-DB-000308
<GroupDescription></GroupDescription>Group -
Azure SQL Database must associate organization-defined types of security labels having organization-defined security label values with information in storage.
<VulnDiscussion>Without the association of security labels to information, there is no basis for Azure SQL Database to make security-related ...Rule Medium Severity -
SRG-APP-000313-DB-000309
<GroupDescription></GroupDescription>Group -
Azure SQL Database must associate organization-defined types of security labels having organization-defined security label values with information in process.
<VulnDiscussion>Without the association of security labels to information, there is no basis for Azure SQL Database to make security-related ...Rule Medium Severity -
SRG-APP-000314-DB-000310
<GroupDescription></GroupDescription>Group -
Azure SQL Database must associate organization-defined types of security labels having organization-defined security label values with information in transmission.
<VulnDiscussion>Without the association of security labels to information, there is no basis for Azure SQL Database to make security-related ...Rule Medium Severity -
SRG-APP-000328-DB-000301
<GroupDescription></GroupDescription>Group -
Azure SQL Database must enforce discretionary access control policies, as defined by the data owner, over defined subjects and objects.
<VulnDiscussion>Discretionary Access Control (DAC) is based on the notion that individual users are "owners" of objects and therefore have di...Rule Medium Severity -
SRG-APP-000342-DB-000302
<GroupDescription></GroupDescription>Group -
Azure SQL Database must restrict execution of stored procedures and functions that utilize [execute as] to necessary cases only.
<VulnDiscussion>In certain situations, to provide required functionality, a DBMS needs to execute internal logic (stored procedures, function...Rule Medium Severity -
SRG-APP-000378-DB-000365
<GroupDescription></GroupDescription>Group -
Azure SQL Database must prohibit user installation of logic modules (stored procedures, functions, triggers, views, etc.) without explicit privileged status.
<VulnDiscussion>Allowing regular users to install software, without explicit privileges, creates the risk that untested or potentially malici...Rule Medium Severity -
SRG-APP-000380-DB-000360
<GroupDescription></GroupDescription>Group -
Azure SQL Database must enforce access restrictions associated with changes to the configuration of the Azure SQL Database server or database(s).
<VulnDiscussion>Failure to provide logical access restrictions associated with changes to configuration may have significant effects on the o...Rule Medium Severity -
SRG-APP-000416-DB-000380
<GroupDescription></GroupDescription>Group -
Azure SQL Database must use NSA-approved cryptography to protect classified information in accordance with the data owners requirements.
<VulnDiscussion>Use of weak or untested encryption algorithms undermines the purposes of utilizing encryption to protect data. The applicatio...Rule High Severity -
SRG-APP-000428-DB-000386
<GroupDescription></GroupDescription>Group -
Azure SQL Database must implement cryptographic mechanisms to prevent unauthorized modification of organization-defined information at rest (to include, at a minimum, PII and classified information) on organization-defined information system components.
<VulnDiscussion>Azure SQL Databases handling data requiring "data at rest" protections must employ cryptographic mechanisms to prevent unauth...Rule Medium Severity -
SRG-APP-000429-DB-000387
<GroupDescription></GroupDescription>Group -
Azure SQL Database must map the PKI-authenticated identity to an associated user account.
<VulnDiscussion>The DOD standard for authentication is DOD-approved PKI certificates. Once a PKI certificate has been validated, it must be m...Rule Medium Severity
Node 2
The content of the drawer really is up to you. It could have form fields, definition lists, text lists, labels, charts, progress bars, etc. Spacing recommendation is 24px margins. You can put tabs in here, and can also make the drawer scrollable.