I have to set passwords for users not to expire,i have to change password every six months.
How can i make password not to expire permanently.
Default tablespace, SPODIL
Temporary tablespace, TEMP
User Created, XXXXXX
Status (locked), OPEN
Password Expire Date, 6/27/20105:59:39 PM (I have to make this expire date to never)
Plz help out.
I get the following error when i try to reset password....
SQL> ALTER PROFILE spodil LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER PROFILE spodil LIMIT PASSWORD_LIFE_TIME UNLIMITED
ERROR at line 1:
ORA-02380: profile SPODIL does not exist