Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find out user password?

ronald_2017Aug 28 2020 — edited Aug 31 2020

Hi All,

In Oracle 11g. As SYS, is it possible to find out user pass? We need to know in order to create a dblinkd from another db.

As far as I know, it can be seen in hash format.

select dbms_metadata.get_ddl('USER','SCOTT') ddl from dual

Thanks

Comments
Post Details
Added on Aug 28 2020
11 comments
8,511 views