Wednesday, November 28, 2012

oracle - password life time


SQL> connect system/***
ERROR:
ORA-28002: the password will expire within 7 days

???
----------
SQL> select profile from dba_users where username='SYSTEM';

PROFILE
------------------------------
DEFAULT

SQL> select resource_name, limit from dba_profiles where profile = 'DEFAULT';

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
...
PASSWORD_LIFE_TIME               180
...

16 rows selected.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

1 comment:

  1. Mдааа - и мен ме ухапа, при това два пъти :-/

    ReplyDelete