No profile (default benchmark)
Rules and Groups employed by this XCCDF Profile
-
SRG-APP-000360-DB-000320
<GroupDescription></GroupDescription>Group -
SQL Server must provide an immediate real-time alert to appropriate support staff of all audit log failures.
<VulnDiscussion>It is critical for the appropriate personnel to be aware if a system is at risk of failing to process audit logs as required....Rule Medium Severity -
SRG-APP-000374-DB-000322
<GroupDescription></GroupDescription>Group -
SQL Server must record time stamps in audit records and application data that can be mapped to Coordinated Universal Time (UTC, formerly GMT).
<VulnDiscussion>If time stamps are not consistently applied and there is no common time reference, it is difficult to perform forensic analys...Rule Medium Severity -
SRG-APP-000380-DB-000360
<GroupDescription></GroupDescription>Group -
SQL Server must enforce access restrictions associated with changes to the configuration of the instance.
<VulnDiscussion>Failure to provide logical access restrictions associated with changes to configuration may have significant effects on the o...Rule Medium Severity -
SRG-APP-000380-DB-000360
<GroupDescription></GroupDescription>Group -
Windows must enforce access restrictions associated with changes to the configuration of the SQL Server instance.
<VulnDiscussion>Failure to provide logical access restrictions associated with changes to configuration may have significant effects on the o...Rule Medium Severity -
SRG-APP-000381-DB-000361
<GroupDescription></GroupDescription>Group -
SQL Server must produce audit records of its enforcement of access restrictions associated with changes to the configuration of SQL Server or database(s).
<VulnDiscussion>Without auditing the enforcement of access restrictions against changes to configuration, it would be difficult to identify a...Rule Medium Severity -
SRG-APP-000383-DB-000364
<GroupDescription></GroupDescription>Group -
SQL Server must disable network functions, ports, protocols, and services deemed by the organization to be nonsecure, in accord with the Ports, Protocols, and Services Management (PPSM) guidance.
<VulnDiscussion>Use of nonsecure network functions, ports, protocols, and services exposes the system to avoidable threats.</VulnDiscussio...Rule Medium Severity -
SRG-APP-000431-DB-000388
<GroupDescription></GroupDescription>Group -
SQL Server must maintain a separate execution domain for each executing process.
<VulnDiscussion>Database management systems can maintain separate execution domains for each executing process by assigning each process a se...Rule Medium Severity -
SRG-APP-000431-DB-000388
<GroupDescription></GroupDescription>Group -
SQL Server services must be configured to run under unique dedicated user accounts.
<VulnDiscussion>Database management systems can maintain separate execution domains for each executing process by assigning each process a se...Rule Medium Severity -
SRG-APP-000454-DB-000389
<GroupDescription></GroupDescription>Group -
When updates are applied to SQL Server software, any software components that have been replaced or made unnecessary must be removed.
<VulnDiscussion>Previous versions of DBMS components that are not removed from the information system after updates have been installed may b...Rule Medium Severity -
SRG-APP-000456-DB-000390
<GroupDescription></GroupDescription>Group -
Security-relevant software updates to SQL Server must be installed within the time period directed by an authoritative source (e.g. IAVM, CTOs, DTMs, and STIGs).
<VulnDiscussion>Security flaws with software applications, including database management systems, are discovered daily. Vendors are constantl...Rule Medium Severity -
SRG-APP-000492-DB-000332
<GroupDescription></GroupDescription>Group -
SQL Server must be able to generate audit records when successful and unsuccessful attempts to access security objects occur.
<VulnDiscussion>Changes to the security configuration must be tracked. This requirement applies to situations where security data is retrie...Rule Medium Severity -
SRG-APP-000494-DB-000345
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful attempts to access categorized information (e.g., classification levels/security levels) occur.
<VulnDiscussion>Changes in categorized information must be tracked. Without an audit trail, unauthorized access to protected data could go un...Rule Medium Severity -
SRG-APP-000495-DB-000327
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful attempts to add privileges/permissions occur.
<VulnDiscussion>Changes in the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unautho...Rule Medium Severity -
SRG-APP-000495-DB-000329
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful attempts to modify privileges/permissions occur.
<VulnDiscussion>Changes in the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unautho...Rule Medium Severity -
SRG-APP-000496-DB-000335
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful attempts to modify security objects occur.
<VulnDiscussion>Changes in the database objects (tables, views, procedures, functions) that record and control permissions, privileges, and r...Rule Medium Severity -
SRG-APP-000498-DB-000347
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful attempts to modify categorized information (e.g., classification levels/security levels) occur.
<VulnDiscussion>Changes in categories of information must be tracked. Without an audit trail, unauthorized access to protected data could go ...Rule Medium Severity -
SRG-APP-000499-DB-000331
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful attempts to delete privileges/permissions occur.
<VulnDiscussion>Changes in the permissions, privileges, and roles granted to users and roles must be tracked. Without an audit trail, unautho...Rule Medium Severity -
SRG-APP-000501-DB-000337
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and 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-000349
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful attempts to delete categorized information (e.g., classification levels/security levels) occur.
<VulnDiscussion>Changes in categorized information must be tracked. Without an audit trail, unauthorized access to protected data could go un...Rule Medium Severity -
SRG-APP-000503-DB-000351
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful logons or connection attempts occur.
<VulnDiscussion>For completeness of forensic analysis, it is necessary to track who/what (a user or other principal) logs on to SQL Server. I...Rule Medium Severity -
SRG-APP-000504-DB-000354
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records for all privileged activities or other system-level access.
<VulnDiscussion>Without tracking privileged activity, it would be difficult to establish, correlate, and investigate the events relating to a...Rule Medium Severity -
SRG-APP-000504-DB-000355
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when unsuccessful attempts to execute privileged activities or other system-level access occur.
<VulnDiscussion>Without tracking privileged activity, it would be difficult to establish, correlate, and investigate the events relating to a...Rule Medium Severity -
SRG-APP-000505-DB-000352
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records showing starting and ending time for user access to the database(s).
<VulnDiscussion>For completeness of forensic analysis, it is necessary to know how long a user's (or other principal's) connection to SQL Ser...Rule Medium Severity -
SRG-APP-000506-DB-000353
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when concurrent logons/connections by the same user from different workstations occur.
<VulnDiscussion>For completeness of forensic analysis, it is necessary to track who logs on to SQL Server. Concurrent connections by the s...Rule Medium Severity -
SRG-APP-000507-DB-000357
<GroupDescription></GroupDescription>Group -
SQL Server must generate audit records when successful and unsuccessful accesses to objects occur.
<VulnDiscussion>Without tracking all or selected types of access to all or selected objects (tables, views, procedures, functions, etc.), it ...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.