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!

Password hash dbms_metadata.get_ddl(user..) returns 'S:00000...'

bp_legendJun 27 2018 — edited Jun 27 2018

Hi,

I have a 12.2 database. I extracted the user and password has information using

dbms_metadata.get_ddl('user','scott')    

But the hash is only a long string of zeros like below.

'S:000000000000000000000000000000000000000000000000000000000000'

What can I do to extract the user's password hash?

thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2018
Added on Jun 27 2018
2 comments
527 views