Skip to Main Content

Password Expiry

Find password expiry date for users, and password lifetime for their profiles.
Execute as sys:

Password Lifetime

Set password lifetime of a profile (in this example profile 'default') to unlimited:

Unlock User

And finally, to unlock a user run the following sql as SYS or SYSTEM: