<section title="21.4. Databases"><subsection title="Objective"><paragraph
    title="21.4.1."


><![CDATA[<p>Database content is protected from personnel without a need-to-know.</p>]]></paragraph>
 </subsection>
<subsection title="Context"> <block title="Scope"><paragraph
    title="21.4.2."


><![CDATA[<p>This section covers information relating to databases and interfaces to databases such as search engines.</p>]]></paragraph>
</block>
</subsection>
<subsection title="Rationale &amp; Controls"> <block title="Data labelling"><paragraph
    title="21.4.3.R.01."

    tags="Data Management,Technical"


><![CDATA[<p>Protective markings can be applied to records, tables or to the database as a whole, depending on structure and use. &nbsp;Query results will often need a protective marking to reflect the aggregate of the information retrieved.</p>]]></paragraph>
<paragraph
    title="21.4.3.C.01."

    tags="Data Management,Technical"


    classification="Top Secret"
    compliance="Must"
    cid="4434"
><![CDATA[<p>Agencies MUST ensure that all classified information stored within a database is associated with an appropriate protective marking if the information:</p><ul>
<li>could be exported to a different system; or</li>
<li>contains differing classifications or different handling requirements.</li>
</ul>]]></paragraph>
<paragraph
    title="21.4.3.C.02."

    tags="Data Management,Technical"


    classification="Top Secret"
    compliance="Must"
    cid="4435"
><![CDATA[<p>Agencies MUST ensure that protective markings are applied with a level of granularity sufficient to clearly define the handling requirements for any classified information retrieved or exported from a database.</p>]]></paragraph>
<paragraph
    title="21.4.3.C.03."

    tags="Data Management,Technical"


    classification="All Classifications"
    compliance="Should"
    cid="4436"
><![CDATA[<p>Agencies SHOULD ensure that all classified information stored within a database is associated with an appropriate protective marking if the information:</p><ul>
<li>could be exported to a different system; or</li>
<li>contains differing classifications or different handling requirements.</li>
</ul>]]></paragraph>
<paragraph
    title="21.4.3.C.04."

    tags="Data Management,Technical"


    classification="All Classifications"
    compliance="Should"
    cid="4437"
><![CDATA[<p>Agencies SHOULD ensure that protective markings are applied with a level of granularity sufficient to clearly define the handling requirements for any classified information retrieved or exported from a database.</p>]]></paragraph>
</block>
<block title="Database files"><paragraph
    title="21.4.4.R.01."

    tags="Data Management,Technical"


><![CDATA[<p>Even though a database may provide access controls to stored data, the database files themselves MUST also be protected.</p>]]></paragraph>
<paragraph
    title="21.4.4.C.01."

    tags="Data Management,Technical"


    classification="Top Secret"
    compliance="Must"
    cid="4440"
><![CDATA[<p>Agencies MUST protect database files from access that bypasses the database’s normal access controls.</p>]]></paragraph>
<paragraph
    title="21.4.4.C.02."

    tags="Data Management,Technical"


    classification="All Classifications"
    compliance="Should"
    cid="4441"
><![CDATA[<p>Agencies SHOULD protect database files from access that bypass normal access controls.</p>]]></paragraph>
</block>
<block title="Accountability"><paragraph
    title="21.4.5.R.01."

    tags="Data Management,Governance"


><![CDATA[<p>If system users’ interactions with databases are not logged and audited, agencies will not be able to appropriately investigate any misuse or compromise of database content.</p>]]></paragraph>
<paragraph
    title="21.4.5.C.01."

    tags="Data Management,Governance"


    classification="Top Secret"
    compliance="Must"
    cid="4444"
><![CDATA[<p>Agencies MUST enable logging and auditing of system users’ actions.</p>]]></paragraph>
<paragraph
    title="21.4.5.C.02."

    tags="Data Management,Governance"


    classification="All Classifications"
    compliance="Should"
    cid="4445"
><![CDATA[<p>Agencies SHOULD ensure that databases provide functionality to allow for auditing of system users’ actions.</p>]]></paragraph>
</block>
<block title="Search engines"><paragraph
    title="21.4.6.R.01."

    tags="Data Management,Technical,Access Control,System Access"


><![CDATA[<p>Even if a search engine restricts viewing of classified information that a system user does not have sufficient security clearances to access, the associated metadata can contain information above the security clearances of the system user. &nbsp;In such cases, restricting access to, or sanitising, this metadata effectively controls the possible release of information the system user is not cleared to view.</p>]]></paragraph>
<paragraph
    title="21.4.6.C.01."

    tags="Data Management,Technical,System Access"


    classification="All Classifications"
    compliance="Must"
    cid="4448"
><![CDATA[<p>If results from database queries cannot be appropriately filtered, agencies MUST ensure that all query results are appropriately sanitised to meet the minimum security clearances of system users.</p>]]></paragraph>
<paragraph
    title="21.4.6.C.02."

    tags="Data Management,Technical,System Access"


    classification="All Classifications"
    compliance="Should"
    cid="4449"
><![CDATA[<p>Agencies SHOULD ensure that system users who do not have sufficient security clearances to view database contents cannot see or interrogate associated metadata in a list of results from a search engine query.</p>]]></paragraph>
</block>
</subsection>
</section>
