Query to get the dba user password value

Please use the below query to get the password value of the dba user.

SELECT 'alter user "' 
   ||username 
   ||'" identified by values ''' 
   ||extract(xmltype(dbms_metadata.get_xml('USER',username)),
   '//USER_T/PASSWORD/text()').getstringval()
   ||''';' old_password 
FROM   dba_users 
WHERE  username = '&USERNAME';

Comments