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
Data Guard Broker control LOG_ARCHIVE_* parametersData Guard Broker control LOG_ARCHIVE_* parameters
转：Let the Data Guard Broker control LOG_ARCHIVE_* param […]
Goldengate replicat优化Goldengate replicat优化
By 徐靖 from:https://cloud.tencent.com/developer/article/ […]