Oracle Passwords - changing, expiring and locking users

Oracle Passwords - changing, expiring and locking users

In Oracle database password expiring is a common issue, to set the password to never expire 

use this query

To check whether the user is locked or the password is expired.

     Select username, account_status from dba_users;

To unlock the account:

     alter user username account unlock;

To lock the account:

     alter user username account lock;

To change the password of the user:

     alter user username identified by password;

To change the password and unlock the account:

     alter user username identified by password account unlock;

To check the password expiry date :

     Select username, expiry_date from dba_users;