| password file [message #173587] |
Tue, 23 May 2006 04:57  |
oradba16
Messages: 54
Registered: September 2005
|
Member |
|
|
hi,
I am using ORACLE 8i in solaris 5.8
i created the profile by
create profile life_time limit
password_life_time 1;
then assigned to user by
alter user test identified by lms1_
profile life_time;
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
by
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
punctuation
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......
with regards
Boo
|
|
|
|
| Re: password file [message #173615 is a reply to message #173587] |
Tue, 23 May 2006 08:12  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Just drop or change the password function you've created by running the utlpwdmg.sql script.
You can also try:
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;
Profile altered. |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
