Retrive password encrypted
Da wiki.gienne.cloud.
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 = 'nome utente da recuperare';