2.3.4 Ensure 'ALLOW_GROUP_ACCESS_TO_SGA' Is Set To `FALSE`

Information

The ALLOW_GROUP_ACCESS_TO_SGA controls Linux group access to shared memory on Linux platforms. By default, database shared memory is created with owner access only.

This is to minimize the attack surface, as setting ALLOW_GROUP_ACCESS_TO_SGA to true will allow linux accounts with the same group membership of the oracle software account owner to access the shared memory and thus the ability to dump data from memory.

Solution

To remediate this setting, execute the following SQL statement.

ALTER SYSTEM SET ALLOW_GROUP_ACCESS_TO_SGA='FALSE' SCOPE=SPFILE;

Note: This parameter is not modifiable at the PDB level. You must modify this parameter at the CDB level.

Impact:

No impact on database operations, but it may impact third party software that requires access to Oracle SGA memory such as security monitoring software.

See Also

https://workbench.cisecurity.org/benchmarks/21740

Item Details

Category: ACCESS CONTROL, MEDIA PROTECTION

References: 800-53|AC-3, 800-53|AC-5, 800-53|AC-6, 800-53|MP-2, CSCv7|14.6

Plugin: OracleDB

Control ID: c04c1121a6b8f12f4592933d0a9ddc1c1d0f687663b5f645070e12fde291372f