|password file [message #173587]
||Tue, 23 May 2006 04:57
Registered: September 2005
I am using ORACLE 8i in solaris 5.8
i created the profile by
create profile life_time limit
then assigned to user by
alter user test identified by lms1_
before this i run the script utlpwdmg.sql script as the user sys.
then restarted the database to make the changes to take affect.
now i decided to reset to default profile........
so i dropped the profile life_time
restarted the database to make changes to take effect.
then i try to change the password once again
alter user test identified by lms;
but itz not changing instead it gives error:
SQL> alter user test identified by lms;
alter user test identified by lms
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20003: Password should contain at least one digit, one character and one
i want to change the password i dont want to use the punctuation or digit.
i simply need to set as password like this 'lms'(alter user test identified by lms) likewise.so wat can i do now....... can any one help me to solve this......