problem with password verify function [message #189948] |
Mon, 28 August 2006 12:52 |
sasa_mn
Messages: 3 Registered: August 2006 Location: Montenegro
|
Junior Member |
|
|
I have problem with function for password verification, called verify_function (file $ORACLE_HOME/rdbms/admin/utlpwdmg.sql). Value for variable old_password is always NULL and because of that check if the password differs from the previous password by at least 3 letters doesn't work correct. Can you tell me what is the problem? Why is old_password always NULL?
This is happend when I connect as sys user and tried to change password for wmsys (or any other user):
conn / as sysdba
alter user wmsys identified by new_password replaced old_password;
or
conn / as sysdba
passw wmsys
When I connect as sys user then old_password in verify_function for all users is NULL. Why?
Thanks,
Sasa
-
Attachment: utlpwdmg.sql
(Size: 5.77KB, Downloaded 1842 times)
[Updated on: Tue, 29 August 2006 04:04] Report message to a moderator
|
|
|
Re: problem with password verify function [message #190358 is a reply to message #189948] |
Wed, 30 August 2006 06:16 |
sasa_mn
Messages: 3 Registered: August 2006 Location: Montenegro
|
Junior Member |
|
|
This is happend when I connect as sys user and tried to change password for wmsys (or any other user):
conn / as sysdba
alter user wmsys identified by new_password replaced old_password;
or
conn / as sysdba
passw wmsys
When I connect as sys user then old_password in verify_function for all users is NULL. Why?
Thanks,
Sasa
|
|
|
|
|