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 […]
《收获，不止SQL优化》 – 调优信息一键生成脚本《收获，不止SQL优化》 – 调优信息一键生成脚本
转：https://cloud.tencent.com/developer/article/1415749 梁 […]
Check long running DML progressCheck long running DML progress
select SQL_ID, OPNAME, SOFAR, TOTALWORK, START_TIME, EL […]