Shulou(Shulou.com)06/01 Report--

How to migrate oracle user passwords to the new environment is listed below:

Select name,spare4 | |';'| | password pwd from sys.user$ where name = 'user'

Oracle generates hash and salt of the password based on the columns spare4 and password of the base table sys.users$.

If the update requires the addition of the values keyword:

Alter user user identified by values''

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.