OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » password file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

password file [message #173586]

Tue, 23 May 2006 04:56

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

Report message to a moderator

Re: password file [message #173595 is a reply to message #173586]

Tue, 23 May 2006 06:20

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 00:17:41 CDT 2024