Skip to Main Content

Password Expiry

Find account status and profile settings for users.
The where clause in the example limits this to Password Life Time, just remove that to see all other settings.
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: