Information
Public database links provide a mechanism for establishing connections between databases, enabling data access across multiple environments.
Public database links pose a security risk because they allow any database user to execute queries or modify data on a remote database, depending on the credentials stored in the link. This can lead to unauthorized access, data breaches, and compliance violations.
Solution
To remove a public database link, execute the following SQL command:
DROP PUBLIC DATABASE LINK <DB_LINK>;
Impact:
Applications relying on public database links may fail after removal. Alternative connection methods (e.g., private database links) may need to be implemented.