mitre / mitre/microsoft-sql-server-2016-instance-stig-baseline

Add missing control code to V3R2

Open
#4 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Ruby
Stars
0
Forks
1
PR merge metrics
No merged PRs in 30d

Description

Latest mappings as of V3R3:

Database:

  Total Mapped Controls:  11
  
  Control Counts ===========================
  Total Controls Available for Delta:  43
       Total Controls Found on XCCDF:  28
  
  Match Statistics =========================
                      Match Controls:  11
          Possible Mismatch Controls:  0
            Duplicate Match Controls:  1
                   No Match Controls:  15
                  New XCDDF Controls:  1
  
  Mapping:
             SV-213764 -> SV-213901
             SV-213766 -> SV-213905
             SV-213770 -> SV-213908
             SV-213779 -> SV-213912
             SV-213775 -> SV-213915
             SV-213776 -> SV-213916
             SV-213777 -> SV-213917
             SV-213784 -> SV-213918
             SV-213785 -> SV-213919
             SV-213786 -> SV-213920
             SV-213788 -> SV-213926

Instance:

  Total Mapped Controls:  33
  
  Control Counts ===========================
  Total Controls Available for Delta:  93
       Total Controls Found on XCCDF:  101
  
  Match Statistics =========================
                      Match Controls:  25
          Possible Mismatch Controls:  8
            Duplicate Match Controls:  5
                   No Match Controls:  60
                  New XCDDF Controls:  3


       SV-213858 -> SV-213930
       SV-213808 -> SV-213932
       SV-213811 -> SV-213937
       SV-213859 -> SV-213939
       SV-213818 -> SV-213941
       SV-213828 -> SV-213952
       SV-213829 -> SV-213953
       SV-213847 -> SV-213956
       SV-213849 -> SV-213957
       SV-213852 -> SV-213963
       SV-213862 -> SV-213969
       SV-213853 -> SV-213970
       SV-213863 -> SV-213977
       SV-213865 -> SV-213979
       SV-213868 -> SV-213983
       SV-213869 -> SV-213984
       SV-213870 -> SV-213985
       SV-213873 -> SV-213988
       SV-213874 -> SV-213989
       SV-213879 -> SV-213994
       SV-213882 -> SV-213995
       SV-213884 -> SV-214000
       SV-213886 -> SV-214008
       SV-213888 -> SV-214014
       SV-213889 -> SV-214015
       SV-213890 -> SV-214016
       SV-213892 -> SV-214018
       SV-213893 -> SV-214025
       SV-213848 -> SV-214028
       SV-213809 -> SV-214029
       SV-213897 -> SV-214045
       SV-213896 -> SV-214046
       SV-265639 -> SV-265870

Add code to the following controls for baseline V3R2:

  • SV-213929 - SQL Server must limit the number of concurrent sessions to an organization-defined number per user for all accounts and/or account types.
  • SV-213931 - SQL Server must be configured to utilize the most-secure authentication method available.
  • SV-213933 - SQL Server must protect against a user falsely repudiating by ensuring all accounts are individual, unique, and not shared.
  • SV-213934 - SQL Server must protect against a user falsely repudiating by ensuring the NT AUTHORITY SYSTEM account is not used for administration.
  • SV-213935 - SQL Server must protect against a user falsely repudiating by ensuring only clearly unique Active Directory user accounts can connect to the instance.
  • SV-213936 - SQL Server must be configured to generate audit records for DoD-defined auditable events within all DBMS/database components.
  • SV-213940 - SQL Server must initiate session auditing upon startup.
  • SV-213942 - SQL Server must by default shut down upon audit failure, to include the unavailability of space for more audit log records; or must be configurable to shut down upon audit failure.
  • SV-213943 - SQL Server must be configurable to overwrite audit log records, oldest first (First-In-First-Out - FIFO), in the event of unavailability of space for more audit log records.
  • SV-213944 - The audit information produced by SQL Server must be protected from unauthorized access, modification, and deletion.
  • SV-213948 - SQL Server must protect its audit configuration from authorized and unauthorized access and modification.
  • SV-213950 - SQL Server must limit privileges to change software modules and links to software external to SQL Server.
  • SV-213951 - SQL Server must limit privileges to change software modules, to include stored procedures, functions and triggers, and links to software external to SQL Server.
  • SV-213954 - Default demonstration and sample databases, database objects, and applications must be removed.
  • SV-213955 - Unused database components, DBMS software, and database objects must be removed.
  • SV-213958 - Access to CLR code must be disabled or restricted, unless specifically required and approved.
  • SV-213959 - Access to Non-Standard extended stored procedures must be disabled or restricted, unless specifically required and approved.
  • SV-213960 - Access to linked servers must be disabled or restricted, unless specifically required and approved.
  • SV-213961 - SQL Server must be configured to prohibit or restrict the use of organization-defined protocols as defined in the PPSM CAL and vulnerability assessments.
  • SV-213962 - SQL Server must be configured to prohibit or restrict the use of organization-defined ports, as defined in the PPSM CAL and vulnerability assessments.
  • SV-213964 - If DBMS authentication using passwords is employed, SQL Server must enforce the DoD standards for password complexity and lifetime.
  • SV-213965 - Contained databases must use Windows principals.
  • SV-213966 - If passwords are used for authentication, SQL Server must transmit only encrypted representations of passwords.
  • SV-213967 - Confidentiality of information during transmission is controlled through the use of an approved TLS version.
  • SV-213968 - SQL Server must enforce authorized access to all PKI private keys stored/utilized by SQL Server.
  • SV-213971 - SQL Server must maintain the authenticity of communications sessions by guarding against man-in-the-middle attacks that guess at Session ID values.
  • SV-213972 - SQL Server must protect the confidentiality and integrity of all information at rest.
  • SV-213974 - The Master Key must be backed up, stored offline and off-site.
  • SV-213975 - SQL Server must prevent unauthorized and unintended information transfer via shared system resources.
  • SV-213976 - SQL Server must prevent unauthorized and unintended information transfer via Instant File Initialization (IFI).
  • SV-213978 - SQL Server must reveal detailed error messages only to the ISSO, ISSM, SA, and DBA.
  • SV-213980 - Use of credentials and proxies must be restricted to necessary cases only.
  • SV-213982 - SQL Server must provide centralized configuration of the content to be captured in audit records generated by all components of SQL Server.
  • SV-213986 - SQL Server must record time stamps in audit records and application data that can be mapped to Coordinated Universal Time (UTC, formerly GMT).
  • SV-213987 - SQL Server must enforce access restrictions associated with changes to the configuration of the instance.
  • SV-213990 - 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.
  • SV-213991 - SQL Server must maintain a separate execution domain for each executing process.
  • SV-213992 - SQL Server services must be configured to run under unique dedicated user accounts.
  • SV-213993 - When updates are applied to SQL Server software, any software components that have been replaced or made unnecessary must be removed.
  • SV-213998 - SQL Server must generate audit records when successful and unsuccessful attempts to access categorized information (e.g., classification levels/security levels) occur.
  • SV-214002 - SQL Server must generate audit records when successful and unsuccessful attempts to modify privileges/permissions occur.
  • SV-214004 - SQL Server must generate audit records when successful and unsuccessful attempts to modify security objects occur.
  • SV-214006 - SQL Server must generate audit records when successful and unsuccessful attempts to modify categorized information (e.g., classification levels/security levels) occur.
  • SV-214010 - SQL Server must generate audit records when successful and unsuccessful attempts to delete security objects occur.
  • SV-214012 - SQL Server must generate audit records when successful and unsuccessful attempts to delete categorized information (e.g., classification levels/security levels) occur.
  • SV-214017 - SQL Server must generate audit records showing starting and ending time for user access to the database(s).
  • SV-214020 - SQL Server must generate audit records when successful and unsuccessful accesses to objects occur.
  • SV-214021 - SQL Server must generate audit records for all direct access to the database(s).
  • SV-214022 - SQL Server must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to provision digital signatures.
  • SV-214023 - SQL Server must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to generate and validate cryptographic hashes.
  • SV-214024 - SQL Server must implement NIST FIPS 140-2 or 140-3 validated cryptographic modules to protect unclassified information requiring confidentiality and cryptographic protection, in accordance with the data owners requirements.
  • SV-214026 - SQL Server must configure Customer Feedback and Error Reporting.
  • SV-214027 - SQL Server must configure SQL Server Usage and Error Reporting Auditing.
  • SV-214030 - Execution of startup stored procedures must be restricted to necessary cases only.
  • SV-214031 - SQL Server Mirroring endpoint must utilize AES encryption.
  • SV-214032 - SQL Server Service Broker endpoint must utilize AES encryption.
  • SV-214033 - SQL Server execute permissions to access the registry must be revoked, unless specifically required and approved.
  • SV-214034 - Filestream must be disabled, unless specifically required and approved.
  • SV-214035 - Ole Automation Procedures feature must be disabled, unless specifically required and approved.
  • SV-214036 - SQL Server User Options feature must be disabled, unless specifically required and approved.
  • SV-214037 - Remote Access feature must be disabled, unless specifically required and approved.
  • SV-214038 - Hadoop Connectivity feature must be disabled, unless specifically required and approved.
  • SV-214039 - Allow Polybase Export feature must be disabled, unless specifically required and approved.
  • SV-214040 - Remote Data Archive feature must be disabled, unless specifically required and approved.
  • SV-214041 - SQL Server External Scripts Enabled feature must be disabled, unless specifically required and approved.
  • SV-214042 - The SQL Server Browser service must be disabled unless specifically required and approved.
  • SV-214043 - SQL Server Replication Xps feature must be disabled, unless specifically required and approved.
  • SV-214044 - If the SQL Server Browser Service is specifically required and approved, SQL instances must be hidden.

List of controls:
SV-213929, SV-213931, SV-213933, SV-213934, SV-213935, SV-213936, SV-213940, SV-213942, SV-213943, SV-213944
SV-213948, SV-213950, SV-213951, SV-213954, SV-213955, SV-213958, SV-213959, SV-213960, SV-213961, SV-213962
SV-213964, SV-213965, SV-213966, SV-213967, SV-213968, SV-213971, SV-213972, SV-213974, SV-213975, SV-213976
SV-213978, SV-213980, SV-213982, SV-213986, SV-213987, SV-213990, SV-213991, SV-213992, SV-213993, SV-213998
SV-214002, SV-214004, SV-214006, SV-214010, SV-214012, SV-214017, SV-214020, SV-214021, SV-214022, SV-214023
SV-214024, SV-214026, SV-214027, SV-214030, SV-214031, SV-214032, SV-214033, SV-214034, SV-214035, SV-214036
SV-214037, SV-214038, SV-214039, SV-214040, SV-214041, SV-214042, SV-214043, SV-214044

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating the existing V3R2 control implementations and any mappings for the listed SV identifiers. Compare those patterns with the V3R3 mapping and determine the expected validation for each SQL Server control. Done means all listed controls have implementations and the profile validates them.

Written by the indexing model from the issue text.

Assessment

Tech stack
ruby, sql
Domain
databases, security
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.