-
please... please... look at the code!
You are going to give hrishy a heart attack.
here is what you coded...
Code:
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?
-
Hi Trina
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
Code:
CREATE PROFILE TRINA_PROFILE;
ALTER PROFILE TRINA_PROFILE
LIMIT
password_verify_function trina_verify_function;
ALTER USER TRINA
PROFILE TRINA_PROFILE;
alter user trina identified by trina_7777777777;
alter user trina identified by trina_B77777777;
Pavb
you guessed it right i did a have anxious moments :-D
-
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.
Thanks,
Trina
SQL> select username, profile from dba_users
2 where username = 'TRINA';
USERNAME PROFILE
------------ ------------------------------
TRINA TRINA_PROFILE
SQL> select * from dba_profiles
2 where profile = 'TRINA_PROFILE'
3 and resource_name = 'PASSWORD_VERIFY_FUNCTION';
PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------- -------------------------------- -------- ---------------------
TRINA_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD TRINA_VERIFY_FUNCTION