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
|
|
|
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
|
|
|