dbaplus Community

Feb 13, 2016 · Databases

Unlock Oracle Users Without Changing Passwords: Bypass Expired Password Locks

This article explains how Oracle DBAs can restore access for users whose passwords have expired and become locked by leveraging the password hash in DBA_USERS (or USER$) to reset the account without knowing the original password, while detailing relevant profile parameters and status codes.