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!

getting *hash* value password in 12c

user8875620Apr 27 2016 — edited Apr 28 2016

I have query to get hash value password.  It works in 11g.  But in 12c, some users are retrieving blanks.

this is the query:

select  extract(xmltype(dbms_metadata.get_xml('USER',username)),'//USER_T/PASSWORD/text()').getStringVal()

from dba_users;

some users are ok.  But some users like these are getting empty passwords:

ANONYMOUS

APEX_040200

C##DBFS_ADM1

GSMADMIN_INTERNAL

ORACLE_OCM

...

more

Do I need to user another query for 12c database?

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2016
Added on Apr 27 2016
12 comments
7,659 views