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='PEACOCK';
Save user password
Categories:
Related Post
Steps to Create and Transfer Profile from One Database to AnotherSteps to Create and Transfer Profile from One Database to Another
1. Create SQL Profile in SCOTT schema The SQL Profile i […]