DB-hub Technology Oracle Save user password

Save user password

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';

Leave a Reply

您的邮箱地址不会被公开。 必填项已用 * 标注

Related Post