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$ ;

5 Responses so far.

  1. Very interesting blog Thank you for sharing such a nice and interesting blog.
    Oracle Fusion Financials Online Training

  2. Very interesting blog Awesome post. your article is really informative and helpful for me and other bloggers too Oracle Fusion HCM Online Training

  3. Really very helpful article , Thank you for sharing and interesting blog Oracle Fusion Technical Online Training

  4. Nice Blog Really excellent information and thank you for giving your valuable information


    Big Data and Hadoop Online Training
    Big Data Hadoop Training
    Hyderabad

Powered by Blogger.

Page Views

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