Home » RDBMS Server » Server Administration » Password length
Password length [message #58437] Tue, 26 August 2003 11:56 Go to next message
June Wang
Messages: 5
Registered: August 2003
Junior Member
We let users change their own passwords. But only one character is valid for Oracle password. How do we limited at least 5 characters to be a valid password? Thanks.
Re: Password length [message #58439 is a reply to message #58437] Tue, 26 August 2003 12:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you have to make use of password_verify_function
Re: Password length [message #58440 is a reply to message #58439] Tue, 26 August 2003 19:06 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Hello,
call the verify_function (username varchar2,password varchar2)...
begin. ..
IF length(password) < 4 THEN
raise_application_error(-20002, 'Password length less than 4');
END IF;
end;

and call that verify_function as a parameter of password_verify_function...

hope that helps...
sai
Re: Password length [message #58474 is a reply to message #58440] Fri, 29 August 2003 15:19 Go to previous message
Kartik Nair
Messages: 15
Registered: August 2003
Junior Member
Make use of the verify funtion.

if length(password) < 5
then raise_application_error(-20003,'The password should be of atleast 5 Characters');
end if;

Cheers!
Previous Topic: ORA-04030 Out of process memory
Next Topic: Installing Oracle8i question
Goto Forum:
  


Current Time: Fri Sep 20 09:46:34 CDT 2024