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 коммент. »
Оставьте Ваш комментарий