Monday, July 2, 2012

Oracle User expired password

Use this command to extract the password and generate the ALTER user statement needed to un-expire an oracle 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 = 'username';

0 comments:

Post a Comment