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
hint to enforce FULL SCAN with direct path readhint to enforce FULL SCAN with direct path read
from https://community.oracle.com/tech/apps-infra/discu […]
《收获，不止SQL优化》 – 调优信息一键生成脚本《收获，不止SQL优化》 – 调优信息一键生成脚本
转：https://cloud.tencent.com/developer/article/1415749 梁 […]
Oracle Database 12c: PSUs vs database proactive bundle patchesOracle Database 12c: PSUs vs database proactive bundle patches
转载： by Simon Pane June 14, 2016 https://blog.pythian.co […]