II - Mission Support Public
Rules and Groups employed by this XCCDF Profile
-
SRG-APP-000231-DB-000154
<GroupDescription></GroupDescription>Group -
The Service Master Key must be backed up, stored offline and off-site.
<VulnDiscussion>Backup and recovery of the Service Master Key may be critical to the complete recovery of the database. Not having this key c...Rule Medium Severity -
SRG-APP-000023-DB-000001
<GroupDescription></GroupDescription>Group -
SQL Server authentication and identity management must be integrated with an organization-level authentication/access mechanism providing account management and automation for all users, groups, roles, and any other principals.
<VulnDiscussion>Enterprise environments make account management for applications and databases challenging and complex. A manual process for ...Rule Medium Severity -
SRG-APP-000091-DB-000325
<GroupDescription></GroupDescription>Group -
Where SQL Server Audit is in use, SQL Server must generate audit records when unsuccessful attempts to retrieve privileges/permissions occur.
<VulnDiscussion>Under some circumstances, it may be useful to monitor who/what is reading privilege/permission/role information. Therefore, i...Rule Medium Severity -
SRG-APP-000109-DB-000321
<GroupDescription></GroupDescription>Group -
Where availability is paramount, the SQL Server must continue processing (preferably overwriting existing records, oldest first), in the event of lack of space for more Audit/Trace log records; and must keep processing after any failure of an Audit/Trace.
<VulnDiscussion>It is critical that when SQL Server is at risk of failing to process audit logs as required, it take action to mitigate the f...Rule High 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 SQL Server, etc.) must be restricted to authorized users.
<VulnDiscussion>If SQL Server were to allow any user to make changes to database structure or logic, then those changes might be implemented ...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.