Home » RDBMS Server » Backup & Recovery » password file
password file [message #173586] Tue, 23 May 2006 04:56 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 #173595 is a reply to message #173586] Tue, 23 May 2006 06:20 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Restarting the database isn't necessary for these changes to take affect. Disconnecting and reconnecting, but not restarting.

If you ran the utlpwdmg.sql without any modifications, this script will actually modify the DEFAULT profile which the user TEST should be assigned now.

Issue the following query to verify if the user is affected by the password function:

select a.username, a.profile, b.limit
	from dba_users a, dba_profiles b
	where a.profile = b.profile
	and b.resource_name = 'PASSWORD_VERIFY_FUNCTION'
	and a.username = 'TEST';

[Updated on: Tue, 23 May 2006 06:37]

Report message to a moderator

Previous Topic: oracle error ORA-01200
Next Topic: initialization of internal recovery manager package failed
Goto Forum:
  


Current Time: Sun Nov 24 18:08:53 CST 2024