Our Audit Company has given us a recommendation:
"Old DB Link encrypted Passwords: The password of the Oracle databases links are encrypted using DES (password starts with 05). This encryption methord is known and users can decrypt the passwords using a simple SQL query. Please recreate the database links to use the new encryption method (password starts with 06)."
What does it mean and how can we perform this recommendation?
can you try to drop and recreate the database links after making sure parameter compatible is set to the current
version and also that parameter sec_case_sensitive_logon = TRUE ?
The old version passwords were likely found with a sql similar to this one:
select name, host, userid from sys.link$ where PASSWORDX like '05%';
Harm ten Napel