,

ORA-28001: the password has expired

четверг, 26 сентября 2013 г. Оставить комментарий

Cause: The user's account has expired and the password needs to be changed.

Action: Change the password.


SQL> select dba_users.account_status
2 from dba_users
3 where dba_users.username = 'INFD_T';

ACCOUNT_STATUS
--------------------------------
EXPIRED

SQL> ALTER USER INFD_T IDENTIFIED BY INFD_T;

User altered

SQL>
SQL> select dba_users.account_status
2 from dba_users
3 where dba_users.username = 'INFD_T';

ACCOUNT_STATUS
--------------------------------
OPEN

SQL>

Other methods:


ALTER USER < USERNAME > IDENTIFIED BY < PASSWORD >;
ALTER USER < USERNAME > IDENTIFIED BY VALUES < PASSWORD_HASH >;

0 коммент. »

Оставьте Ваш комментарий