How to get rid of ORA-28002?

Jul 30, 2015 10:44AM

My application user getting,

ORA-28002 message the password will expire within 7 days?

The database is Oracle 11g r2 on Windows2012.

Please advise me to have the user's password never expired. Thank you

SQL> select * from dba_users where username='MYUSER>';

USERNAME USER_ID PASSWORD

------------------------------ ---------- ------------------------------

ACCOUNT_STATUS LOCK_DATE EXPIRY_DA

-------------------------------- --------- ---------

DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED

------------------------------ ------------------------------ ---------

PROFILE INITIAL_RSRC_CONSUMER_GROUP

------------------------------ ------------------------------

EXTERNAL_NAME

-------------------------------------------------------------------------

PASSWORD E AUTHENTI

-------- - --------

MYUSER 93

EXPIRED(GRACE) 06-AUG-15

PRC_DATA_TS TEMP 31-JAN-15

DEFAULT DEFAULT_CONSUMER_GROUP

10G 11G N PASSWORD

Database Administration (MOSC)