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
《收获，不止SQL优化》 – 调优信息一键生成脚本《收获，不止SQL优化》 – 调优信息一键生成脚本
转：https://cloud.tencent.com/developer/article/1415749 梁 […]
How do I calculate tables size in OracleHow do I calculate tables size in Oracle
This query tells you how much space is allocated for ea […]
Goldengate replicat优化Goldengate replicat优化
By 徐靖 from:https://cloud.tencent.com/developer/article/ […]