====================================
To get encrypted password of a user.
===================================
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 = 'GLOGOWNER';
No comments:
Post a Comment