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 UNIX platforms. 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;

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/16474

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