Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle user password encryption has all zeros

793316Apr 24 2023

One my Oracle DB user has encrypted password set to all Zeros. I extracted the encrypted password from user DDL and I see all zeros.

ALTER USER "xxxx" IDENTIFIED BY VALUES 'S:000000000000000000000000000000000000000000000000000000000000';

What does this mean and how did it happen ? We had DB patching during that time. The user is not able to connect. He gets invalid username/ password error.

DB Version : 19.18.0.0 ( 19c Enterprise Edition )

OS : Linux 7

This post has been answered by 793316 on Jul 12 2023
Jump to Answer
Comments
Post Details
Added on Apr 24 2023
4 comments
2,927 views