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.

41 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

Powered by Blogger.

Page Views

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