The Database STIG's System Security Plan

Published Mar 23 2019 12:23 PM 265 Views
Microsoft
First published on TECHNET on Nov 10, 2011

The Database STIG requires a written System Security Plan, and it's the responsibility of the Information Assurance Officer (IAO) to create it (see section 3.1.9 below). Although the DBA doesn't create it, the DBA can advise the IAO, and the DBA is required to maintain compliance with the security plan.


The following excerpts are from the Database STIG, V8R1, and include every reference to "Security Plan":


3.1.4.3 Unique security requirements (encryption of sensitive data)


Access to sensitive data may not always be sufficiently protected by authorizations and requires encryption. In some cases, the required encryption may be provided by the application accessing the database. In others, the DBMS may be configured to provide the data encryption. When the DBMS provides the encryption, the requirement must be implemented as identified by the Information Owner to prevent unauthorized disclosure or access.


(DG0106: CAT II) The DBA will ensure security requirements specific to the use of the database are configured as identified in the System Security Plan.


3.1.4.5 Restoration priority of subsystems is identified


When DBMS service is disrupted, the impact it has on the overall mission of the organization can be severe. Without the proper assignment of the priority to be placed on restoration of the DBMS and its subsystems, restoration of DBMS services may not meet mission requirements.


(DG0108: CAT III) The IAO will ensure the restoration priority of the database and its supporting subsystems are identified in the System Security Plan.


3.1.6 Partitioning the Application (DCPA)


[content skipped]


(DG0109: CAT II) The IAO will ensure the DBMS host is dedicated to support of the DBMS and is not shared with other application services including web, application, file, print, or other services unless mission or operationally required and documented in the System Security Plan.


3.1.9 IA Documentation (DCSD)


A System Security Plan defines the security procedures and policies applicable to the AIS. It includes definition of responsibilities and qualifications for those responsible for administering the security of the AIS [Automated Information System]. For databases, this includes specifically the DBA in addition to the standard SA and IAO roles. Without a security plan, unqualified personnel may be assigned responsibilities that they are incapable of meeting and the database security is prone to an inconsistent and incomplete implementation.


(DG0153: CAT III) The IAO will assign and authorize DBA responsibilities for the DBMS.


(DG0156: CAT III) The IAM will assign and authorize IAO responsibilities for the DBMS.


(DG0154: CAT III) The IAO will ensure the DBMS is included in or has defined for it a System Security Plan.


3.3.4 Changes to Data (ECCD)


The responsibility for managing the auditing configuration for data access may or may not fall to the DBA. In some cases, applications may incorporate their own auditing capability. Where the application depends on the DBMS to provide the auditing of changes to data, the responsibility for auditing for changes to data falls to the DBA. Auditing of changes to sensitive data can provide not only accountability, but also the ability to restore data to the correct value or content.


(DG0031: CAT II) The DBA will configure auditing of access or changes to data in accordance with the application requirements specified in the System Security Plan.


3.3.8 Interconnections among DoD systems and Enclaves (ECIC)


Applications that access databases and databases connecting to remote databases that differ in their assigned classification levels may expose sensitive data to unauthorized clients. Any interconnections between databases or applications and databases differing in classification levels are required to comply with interface control rules. This requirement is covered in depth in the Enclave STIG and is listed here to heighten awareness of the requirement during application and DBMS design and planning.


(DG0171: CAT II) The DBA will ensure interconnections between databases or other applications operating at different classification levels are identified and their communications configured to comply with the interface controls specified in the System Security Plan.


3.3.10 Logon (ECLO)


[content skipped]


(DG0073: CAT II) The DBA will configure the DBMS to lock database accounts after three or an IAO-specified number of consecutive unsuccessful connection attempts within a 60 minute period. The counter may be reset to 0 if a third failed logon attempt does not occur before reset. Where this requirement is not compatible with the operation of a front-end application, the unsuccessful logon count and time will be specified and the operational need documented in the System Security Plan.


[requirement skipped]


(DG0134: CAT II) The DBA will configure where supported by the DBMS a limit of concurrent connections by a single database account to the limit specified in the System Security Plan, a number determined by testing or review of logs to be appropriate for the application. The limit will not be set to unlimited except where operationally required and documented in the System Security Plan.


[requirement skipped]


(DG0160: CAT III) The DBA will ensure database connection attempts are limited to a specific number of times within a specific time period as specified in the System Security Plan. The limit will not be set to unlimited.


3.3.12 Marking and Labeling (ECML)


A database user that does not know the sensitivity level of the data being accessed cannot be expected to protect it in accordance with requirements. While normally marking and labeling of the data is handled by the application displaying the data, many applications provided with the DBMS software may not provide this capability. Use or access to any application that cannot display sensitivity labels must be restricted to protect the data from inadvertent disclosure. Where the marking and labeling of the data can be configured by the DBMS, it must be assigned in accordance with the direction of the Information Owner.


(DG0087: CAT III) The DBA will configure DBMS marking and labeling of non-public data where required in accordance with the System Security Plan.


%3CLINGO-SUB%20id%3D%22lingo-sub-383946%22%20slang%3D%22en-US%22%3EThe%20Database%20STIG's%20System%20Security%20Plan%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-383946%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Nov%2010%2C%202011%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EThe%20Database%20STIG%20requires%20a%20written%20System%20Security%20Plan%2C%20and%20it's%20the%20responsibility%20of%20the%20Information%20Assurance%20Officer%20(IAO)%20to%20create%20it%20(see%20section%203.1.9%20below).%20Although%20the%20DBA%20doesn't%20create%20it%2C%20the%20DBA%20can%20advise%20the%20IAO%2C%20and%20the%20DBA%20is%20required%20to%20maintain%20compliance%20with%20the%20security%20plan.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThe%20following%20excerpts%20are%20from%20the%26nbsp%3BDatabase%20STIG%2C%20V8R1%2C%20and%20include%20every%20reference%20to%20%22Security%20Plan%22%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.1.4.3%20Unique%20security%20requirements%20(encryption%20of%20sensitive%20data)%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EAccess%20to%20sensitive%20data%20may%20not%20always%20be%20sufficiently%20protected%20by%20authorizations%20and%20requires%20encryption.%20In%20some%20cases%2C%20the%20required%20encryption%20may%20be%20provided%20by%20the%20application%20accessing%20the%20database.%20In%20others%2C%20the%20DBMS%20may%20be%20configured%20to%20provide%20the%20data%20encryption.%20When%20the%20DBMS%20provides%20the%20encryption%2C%20the%20requirement%20must%20be%20implemented%20as%20identified%20by%20the%20Information%20Owner%20to%20prevent%20unauthorized%20disclosure%20or%20access.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0106%3A%20CAT%20II)%20The%20DBA%20will%20ensure%20security%20requirements%20specific%20to%20the%20use%20of%20the%20database%20are%20configured%20as%20identified%20in%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.1.4.5%20Restoration%20priority%20of%20subsystems%20is%20identified%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EWhen%20DBMS%20service%20is%20disrupted%2C%20the%20impact%20it%20has%20on%20the%20overall%20mission%20of%20the%20organization%20can%20be%20severe.%20Without%20the%20proper%20assignment%20of%20the%20priority%20to%20be%20placed%20on%20restoration%20of%20the%20DBMS%20and%20its%20subsystems%2C%20restoration%20of%20DBMS%20services%20may%20not%20meet%20mission%20requirements.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0108%3A%20CAT%20III)%20The%20IAO%20will%20ensure%20the%20restoration%20priority%20of%20the%20database%20and%20its%20supporting%20subsystems%20are%20identified%20in%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.1.6%20Partitioning%20the%20Application%20(DCPA)%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%5Bcontent%20skipped%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0109%3A%20CAT%20II)%20The%20IAO%20will%20ensure%20the%20DBMS%20host%20is%20dedicated%20to%20support%20of%20the%20DBMS%20and%20is%20not%20shared%20with%20other%20application%20services%20including%20web%2C%20application%2C%20file%2C%20print%2C%20or%20other%20services%20unless%20mission%20or%20operationally%20required%20and%20documented%20in%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.1.9%20IA%20Documentation%20(DCSD)%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EA%20System%20Security%20Plan%20defines%20the%20security%20procedures%20and%20policies%20applicable%20to%20the%20AIS.%20It%20includes%20definition%20of%20responsibilities%20and%20qualifications%20for%20those%20responsible%20for%20administering%20the%20security%20of%20the%20AIS%20%5BAutomated%20Information%20System%5D.%20For%20databases%2C%20this%20includes%20specifically%20the%20DBA%20in%20addition%20to%20the%20standard%20SA%20and%20IAO%20roles.%20Without%20a%20security%20plan%2C%20unqualified%20personnel%20may%20be%20assigned%20responsibilities%20that%20they%20are%20incapable%20of%20meeting%20and%20the%20database%20security%20is%20prone%20to%20an%20inconsistent%20and%20incomplete%20implementation.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0153%3A%20CAT%20III)%20The%20IAO%20will%20assign%20and%20authorize%20DBA%20responsibilities%20for%20the%20DBMS.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0156%3A%20CAT%20III)%20The%20IAM%20will%20assign%20and%20authorize%20IAO%20responsibilities%20for%20the%20DBMS.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0154%3A%20CAT%20III)%20The%20IAO%20will%20ensure%20the%20DBMS%20is%20included%20in%20or%20has%20defined%20for%20it%20a%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.3.4%20Changes%20to%20Data%20(ECCD)%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThe%20responsibility%20for%20managing%20the%20auditing%20configuration%20for%20data%20access%20may%20or%20may%20not%20fall%20to%20the%20DBA.%20In%20some%20cases%2C%20applications%20may%20incorporate%20their%20own%20auditing%20capability.%20Where%20the%20application%20depends%20on%20the%20DBMS%20to%20provide%20the%20auditing%20of%20changes%20to%20data%2C%20the%20responsibility%20for%20auditing%20for%20changes%20to%20data%20falls%20to%20the%20DBA.%20Auditing%20of%20changes%20to%20sensitive%20data%20can%20provide%20not%20only%20accountability%2C%20but%20also%20the%20ability%20to%20restore%20data%20to%20the%20correct%20value%20or%20content.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0031%3A%20CAT%20II)%20The%20DBA%20will%20configure%20auditing%20of%20access%20or%20changes%20to%20data%20in%20accordance%20with%20the%20application%20requirements%20specified%20in%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.3.8%20Interconnections%20among%20DoD%20systems%20and%20Enclaves%20(ECIC)%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EApplications%20that%20access%20databases%20and%20databases%20connecting%20to%20remote%20databases%20that%20differ%20in%20their%20assigned%20classification%20levels%20may%20expose%20sensitive%20data%20to%20unauthorized%20clients.%20Any%20interconnections%20between%20databases%20or%20applications%20and%20databases%20differing%20in%20classification%20levels%20are%20required%20to%20comply%20with%20interface%20control%20rules.%20This%20requirement%20is%20covered%20in%20depth%20in%20the%20%3CI%3E%20Enclave%20STIG%20%3C%2FI%3E%20and%20is%20listed%20here%20to%20heighten%20awareness%20of%20the%20requirement%20during%20application%20and%20DBMS%20design%20and%20planning.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0171%3A%20CAT%20II)%20The%20DBA%20will%20ensure%20interconnections%20between%20databases%20or%20other%20applications%20operating%20at%20different%20classification%20levels%20are%20identified%20and%20their%20communications%20configured%20to%20comply%20with%20the%20interface%20controls%20specified%20in%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.3.10%20Logon%20(ECLO)%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%5Bcontent%20skipped%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0073%3A%20CAT%20II)%20The%20DBA%20will%20configure%20the%20DBMS%20to%20lock%20database%20accounts%20after%20three%20or%20an%20IAO-specified%20number%20of%20consecutive%20unsuccessful%20connection%20attempts%20within%20a%2060%20minute%20period.%20The%20counter%20may%20be%20reset%20to%200%20if%20a%20third%20failed%20logon%20attempt%20does%20not%20occur%20before%20reset.%20Where%20this%20requirement%20is%20not%20compatible%20with%20the%20operation%20of%20a%20front-end%20application%2C%20the%20unsuccessful%20logon%20count%20and%20time%20will%20be%20specified%20and%20the%20operational%20need%20documented%20in%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%5Brequirement%20skipped%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0134%3A%20CAT%20II)%20The%20DBA%20will%20configure%20where%20supported%20by%20the%20DBMS%20a%20limit%20of%20concurrent%20connections%20by%20a%20single%20database%20account%20to%20the%20limit%20specified%20in%20the%20System%20Security%20Plan%2C%20a%20number%20determined%20by%20testing%20or%20review%20of%20logs%20to%20be%20appropriate%20for%20the%20application.%20The%20limit%20will%20not%20be%20set%20to%20unlimited%20except%20where%20operationally%20required%20and%20documented%20in%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%5Brequirement%20skipped%5D%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0160%3A%20CAT%20III)%20The%20DBA%20will%20ensure%20database%20connection%20attempts%20are%20limited%20to%20a%20specific%20number%20of%20times%20within%20a%20specific%20time%20period%20as%20specified%20in%20the%20System%20Security%20Plan.%20The%20limit%20will%20not%20be%20set%20to%20unlimited.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CB%3E%203.3.12%20Marking%20and%20Labeling%20(ECML)%20%3C%2FB%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EA%20database%20user%20that%20does%20not%20know%20the%20sensitivity%20level%20of%20the%20data%20being%20accessed%20cannot%20be%20expected%20to%20protect%20it%20in%20accordance%20with%20requirements.%20While%20normally%20marking%20and%20labeling%20of%20the%20data%20is%20handled%20by%20the%20application%20displaying%20the%20data%2C%20many%20applications%20provided%20with%20the%20DBMS%20software%20may%20not%20provide%20this%20capability.%20Use%20or%20access%20to%20any%20application%20that%20cannot%20display%20sensitivity%20labels%20must%20be%20restricted%20to%20protect%20the%20data%20from%20inadvertent%20disclosure.%20Where%20the%20marking%20and%20labeling%20of%20the%20data%20can%20be%20configured%20by%20the%20DBMS%2C%20it%20must%20be%20assigned%20in%20accordance%20with%20the%20direction%20of%20the%20Information%20Owner.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CI%3E%20(DG0087%3A%20CAT%20III)%20The%20DBA%20will%20configure%20DBMS%20marking%20and%20labeling%20of%20non-public%20data%20where%20required%20in%20accordance%20with%20the%20System%20Security%20Plan.%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-383946%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Nov%2010%2C%202011%20The%20Database%20STIG%20requires%20a%20written%20System%20Security%20Plan%2C%20and%20it's%20the%20responsibility%20of%20the%20Information%20Assurance%20Officer%20(IAO)%20to%20create%20it%20(see%20section%203.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-383946%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerSecurity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 23 2019 12:23 PM
Updated by: