Home » RDBMS Server » Security » password file
password file [message #173587] Tue, 23 May 2006 04:57 Go to next message
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 Go to previous message
Frank Naude
Messages: 4579
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.
Previous Topic: Anti-Virus S/w for Oracle applications installed Windows server 2003 machine ??
Next Topic: Username/Password for SQLPlus3.3
Goto Forum:
  


Current Time: Thu Mar 28 18:19:00 CDT 2024