Title

The EDB Postgres Advanced Server must associate organization-defined types of security labels having organization-defined security label values with information in storage. (Cat II impact)

Discussion

Without the association of security labels to information, there is no basis for the to make security-related access-control decisions. Security labels are abstractions representing the basic properties or characteristics of an entity (e.g., subjects and objects) with respect to safeguarding information. These labels are typically associated with internal data structures (e.g., tables, rows) within the database and are used to enable the implementation of access control and flow control policies, reflect special dissemination, handling or distribution instructions, or support other aspects of the information security policy. One example includes marking data as classified or CUI. These security labels may be assigned manually or during data processing; either way, it is imperative these assignments are maintained while the data is in storage. If the security labels are lost when the data is stored, there is the risk of a data compromise. The mechanism used to support security labeling may be a feature of the DBMS product, a third-party product, or custom application code.

Check Content

If security labeling is not required, this is not applicable. If security labeling requirements have been specified, execute the following SQL as the "enterprisedb" operating system user: > psql edb -c "SELECT * from ALL_POLICIES where OBJECT_NAME = '<object_name>'" If a policy is not enabled for the table requiring security labeling, this is a finding.

Fix Text

For information on creating row-level policies for all required tables with the DBMS_RLS package, refer to the documentation: https://www.enterprisedb.com/docs/epas/latest/reference/oracle_compatibility_reference/epas_compat_bip_guide/03_built-in_packages/14_dbms_rls/

Additional Identifiers

Rule ID: SV-259269r938860_rule

Vulnerability ID: V-259269

Group Title: SRG-APP-000311-DB-000308

Expert Comments

CCIs tied to check.

Controls tied to check. These are derived from the CCIs shown above.