23 if regexp_instr(password,regular_expr) > 0 THEN
24 -- raise_application_error(-20006, 'Password must contain at least one upper case letter.');
25 return true;
26 end if;
27 -- if everything is fine return false.
28 RETURN (false);
... does it makes sense to you?
10-21-2009, 01:02 AM
I am really curious to know what your profession really is and what are you trying to do with oracle.
You need to create a profile and assign that profile to that user and then do
CREATE PROFILE TRINA_PROFILE;
ALTER PROFILE TRINA_PROFILE
ALTER USER TRINA
alter user trina identified by trina_7777777777;
alter user trina identified by trina_B77777777;
you guessed it right i did a have anxious moments :-D
10-22-2009, 10:44 AM
Hi Hrishy and Pavb,
I responsed to both of you yesterday. I checked this morning and I did not see my posting. I'm resending it again. Before I post my question for assistance, I created an oracle account, profile, and password the password verify function (see below). I was able to test the mininum requirement of the letters, digit, and punctuation, but not successfully on the checking upper letter case. I have googled to find for answer but I tested the code using loop statement that someone at google posted it. I tested the code out but it did not work. Therefore, I thought that I can try it here.
My profession is not developer/programmer. You keep saying looking at the code. I'm going to look it again.
SQL> select username, profile from dba_users
2 where username = 'TRINA';