There is a default password verify function under $ORACLE_HOME/rdbms/admin with filename utlpwdmg.sql. This script creates a password verify function named "verify_function" and alters the default profile with the below attributes:

ALTER PROFILE DEFAULT LIMIT
PASSWORD_LIFE_TIME 60
PASSWORD_GRACE_TIME 10
PASSWORD_REUSE_TIME 1800
PASSWORD_REUSE_MAX UNLIMITED
FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 1/1440
PASSWORD_VERIFY_FUNCTION verify_function;

verify_function has the following attributes:
- Check if the password is same as the username
- Check for the minimum length of the password (default = 4)
- Check if the password is too simple. A dictionary of words may be maintained and a check may be made so as not to allow the words that are too simple for the password. ('welcome', 'database', 'account', 'user', 'password', 'oracle', 'computer', 'abcd' words are not accepted as password by default)
- Check if the password contains at least one letter, one digit and one punctuation mark.
- Check if the password differs from the previous password by at least 3 letters.

You can customize this script to have different password verify function attributes, profile attributes and to apply to another profile.

81 Responses so far.

  1. Path Infotech is in the field of oracle training program from past several years.

    For more info : Oracle Certification Courses

  2. Thanks for sharing this interesting and useful blog..

    Oracle Training Chennai

  3. Amazing post!!Android kernel uses kernel versions from 3.4, 3.10 or 3.18. Android kernel must be in-between these versions. Android is simple to use and very attractive to view. Some of latest android versions are marshmallow but recently a version of android 7 is released and its product name is nougat. Android is completely open source software which was developed by everyone.Thank you..!!
    Regards,
    android training in velachery | Android Training Institutes in Chennai

  4. You have shared useful and important script with us. Keep updating.
    DBA course syllabus | DBA training courses

  5. unknown says:

    Spring is the most popular and innovative community for the Java developers. They have changed the way how to build the enterprise applications and how to manage them. Spring Boot is their latest innovation to keep up to date with the changing technology needs. The primary motivation behind developing Spring Boot is to simplify the process for configuring and deploying the spring applications.
    Spring boot course content

  6. unknown says:

    The Spring Framework is a lightweight framework for developing Java enterprise applications. It provides high performing, easily testable and reusable code. Spring handles the infrastructure as the underlying framework so that you can focus on your application.Spring is modular in design, thereby making creation, handling and linking of individual components so much easier. Spring implements Model View Container(MVC) design pattern.
    spring mvc validation example

  7. Informative blog and it was up to the point describing the information very effectively. Thanks to blog author for wonderful and informative post. Also great with all of the valuable information on mobile app and you are doing well.
    Mobile application developers in Chennai | Android application developers in Chennai

  8. Bagyaraju says:

    Awesome post……. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion HCM Online Training

  9. Prasad says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion SCM Online Training

  10. I wish to show thanks to you just for bailing me out of this particular trouble.As a result of checking through the net and meeting techniques that were not productive, I thought my life was done.
    Selenium Training in Chennai

  11. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  12. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

  13. Thanks for sharing this niche useful informative post to our knowledge.
    brochure designers in chennai | brochure design company in chennai

  14. Santhosh says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    oracle fusion scm online training

  15. harsha says:

    Really thanks for sharing such a wonderful blog.
    Oracle Fusion Financials Online Training

  16. priyanka says:

    I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.
    Best Python training Institute in chennai

  17. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.


    Digital Marketing Training in chennai


  18. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  19. Vikky cmd says:

    Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

    Hadoop Training in Chennai

  20. Thanks for sharing this function, i am utilize this function on my Website, working good thanks


    Tirupati Tour Packages from Chennai | Chennai to Tirupati Package

  21. Latha says:

    I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    Project Centers in Chennai | ME Project Centers Chennai

  22. Vijaya says:

    Great information you are shared, Thanks for sharing most valuable information. keep share on

    IEEE Vlsi Projects in Chennai | IEEE Robotics Projects in Chennai.

  23. Really excellent information and thank you for giving your valuable information

    Oracle Fusion Financials Online Training

  24. Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion SCM Online Training

  25. Your post is just outstanding !!! thanks for such a post, its really going great work.

    Java Training in Chennai | Java Training Institute in Chennai

  26. amilu B says:

    I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    python training in chennai

    python training in bangalore

    python online training

    python training in pune

  27. simbu says:

    Good piece of work ,enjoyed reading it. The precision given here is good. Hoping a lot from you. Thankyou for sharing.
    java training in chennai

    java training in bangalore

    java online training

    java training in pune

  28. simbu says:

    Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
    java training in omr

    java training in annanagar | java training in chennai

    java training in marathahalli | java training in btm layout

    java training in rajaji nagar | java training in jayanagar

  29. amilu B says:

    Excellant post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    python training in annanagar | python training in chennai

    python training in marathahalli | python training in btm layout

    python training in rajaji nagar | python training in jayanagar

  30. digi mark says:

    Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 


    rpa training in Chennai

    rpa training in Chennai

    rpa training in Chennai

    rpa training in velachery

    rpa training in tambaram

    rpa training in sholinganallur

    rpa training in anna nagar

    rpa online training

  31. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..

    rpa training in Chennai

    rpa training in anna nagar | rpa training in marathahalli

    rpa training in btm | rpa training in kalyan nagar

    rpa training in electronic city | rpa training in chennai

    rpa online training | selenium training in training

  32. Pleasant Tips..Thanks for Sharing….We keep up hands on approach at work and in the workplace, keeping our business pragmatic, which recommends we can help you with your tree clearing and pruning in an invaluable and fit way.
    python training in rajajinagar
    Python training in btm
    Python training in usa

  33. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 
    DevOps online Training
    DevOps Training in USA

  34. Awesome post Really excellent information and thank you for giving your valuable information

    Oracle Fusion Financials Online Training

  35. Revathy A says:

    I’ve desired to post about something similar to this on one of my blogs and this has given me an idea. Cool Mat.

    angularjs Training in chennai
    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    angularjs-Training in velachery

  36. Anonymous says:

    UiPath Training in Bangalore by myTectra is one the best UiPath Training. myTectra is the market leader in providing Robotic Process Automation on UiPath
    robotic process automation training in bangalore

  37. MOUNIKA says:

    Awesome post Really excellent information and thank you for giving your valuable information
    Mule Esb Training From India

    Devops Training From India

  38. MOUNIKA says:

    This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
    Online IT Selfplaced Videos

    Sales Force Selfplaced Videos

    My Sql Selfplaced Videos

  39. Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 
    python online training
    python training in OMR
    python training course in chennai

  40. Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
    Blueprism training in Pune

    Blueprism training in Chennai

  41. gowsalya says:

    Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    DevOps online Training

  42. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time. Please keep updating.
    Web Design Training

  43. Bee Yes says:

    Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi

  44. Unknown says:

    Excellent tutorial buddy. Directly I saw your blog and way of teaching was perfect, Waiting for your next tutorial.
    best rpa training institute in chennai | rpa training in velachery | rpa training in chennai omr

  45. gowthunan says:

    The young boys ended up stimulated to read through them and now have unquestionably been having fun with these things.
    fire and safety course in chennai

  46. Unknown says:

    myTectra a global learning solutions company helps transform people and organization to gain real, lasting benefits.Join Today.Ready to Unlock your Learning Potential !Read More...

  47. Aman CSE says:

    Thank you for sharing your article with full of knowledge on Blueprism . You put great efforts to make this article very useful for other who is searching for the knowledge of Blueprism. Requesting you to keep sharing and keep updating the blog as it really helpful for everyone.
    Thanks and Regards,
    Blueprism training cost in Chennai

  48. Divya M says:

    I am really happy with your blog because your article is very unique and powerful for new reader.
    Click here:
    selenium training in chennai
    selenium training in bangalore
    selenium training in Pune
    selenium training in pune
    Selenium Online Training

  49. Marvelous and fascinating article. Incredible things you've generally imparted to us. Much obliged. Simply keep making this kind out of the post.

    Oracle DBA Training
    Oracle PLSQL Training
    Oracle Performance Tunning Training

  50. Very interesting blog Really excellent information and thank you for giving your valuable information Oracle Fusion HCM Online Training

  51. sudha P says:

    Appreciating the persistence you put into your blog and detailed information you provide
    Java training in Chennai | Java training in Bangalore

    Java online training | Java training in Pune

  52. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    Devops Training courses
    Devops Training in Bangalore
    Best Devops Training in pune
    Devops interview questions and answers

  53. Anonymous says:

    I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    SEO Training near me
    SEO Training in Chennai
    SEO Training
    Digital Marketing Chennai
    Digital Marketing Courses in Chennai
    Digital marketing courses

  54. Praylin S says:

    That's an interesting post. I just came across your post and I'm very much impressed. Thank you so much for your great effort. Looking forward to such great contents.
    Oracle Training |
    Oracle institute in Chennai |
    Oracle course in Chennai |

  55. Your post is really awesome. Your blog is really helpful for me to develop my skills in a right way. Thanks for sharing this unique information with us.
    - Digital Marketing course in Bangalore-Learn Digital Academy

  56. This post is much helpful for us. This is really very massive value to all the readers and it will be the only reason for the post to get popular with great authority.
    Java J2ee Training in Chennai
    German Training Institute in Chennai
    german language coaching centres in chennai
    Java Coaching Center in Chennai
    Best Java Training in Chennai
    German Training Centers in Chennai


Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -