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
Oracle Dataguard setup for CDBsOracle Dataguard setup for CDBs
primary=cdb141 standby=cdb481 1. DB Arcive-Log Mode Ver […]
Create Role and grant to userCreate Role and grant to user
Traget: grant user abc with read only access to all the […]
Check long running DML progressCheck long running DML progress
select SQL_ID, OPNAME, SOFAR, TOTALWORK, START_TIME, EL […]