Document Type | Technical Information
Category | Administration
Applicable Product Versions | T6, T7.
Document Number | TADTI190
Overview
This document describes how to update user passwords to the same value by using the ENCRYPTED option.
Method
<Configuration Method>
Check the password encryption method
select name, dflt_value, value from sys._VT_PARAMETER where name='_CRYPTO_LEVEL';
_CRYPTO_LEVEL - 0 : md5
_CRYPTO_LEVEL - 1 : sha256
Check the password according to the encryption method
1) _CRYPTO_LEVEL=1
select b.reserved4 from sys._dd_user b , dba_users a where b.user_id=a.user_id;2) _CRYPTO_LEVEL=0
select b.password from sys._dd_user b , dba_users a where b.user_id=a.user_id;Use the value extracted from 2 to change the password
ex)
ALTER USER TIBERO IDENTIFIED BY ENCRYPTED 'AzvZSxFo1+Tw1kTDyV41vw==';