Remote database or other external access must use fully-qualified names.
Severity | Group ID | Group Title | Version | Rule ID | Date | STIG Version |
---|---|---|---|---|---|---|
medium | V-219872 | SRG-APP-000516-DB-000363 | O121-BP-026300 | SV-219872r961863_rule | 2025-02-12 | 3 |
Description |
---|
The Oracle GLOBAL_NAMES parameter is used to set the requirement for database link names to be the same name as the remote database whose connection they define. By using the same name for both, ambiguity is avoided and unauthorized or unintended connections to remote databases are less likely. |
ℹ️ Check |
---|
From SQL*Plus: select value from v$parameter where name = 'global_names'; If the value returned is FALSE, this is a finding. |
✔️ Fix |
---|
From SQL*Plus: alter system set global_names = TRUE scope = spfile; Note: This parameter, if changed, will affect all currently defined Oracle database links. The above SQL*Plus command will set the parameter to take effect at next system startup. |