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
Post a Comment