DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: code to check the password at least one upper case letter

  1. #21
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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?
    Last edited by PAVB; 10-20-2009 at 08:17 PM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  2. #22
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #23
    Join Date
    Oct 2000
    Posts
    144
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width