Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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
416 views