If you create a database link like this:

create database link MY_LINK connect to SOME_USER identified by SOME_USER_PASSWORD using 'tns_alias' ;

Then a user with 'SELECT ANY DICTIONARY' would be able to see the password in clear text with this query:

select * from sys.link$ ;

One Response so far.

  1. Sanjay says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion SCM Online Training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -