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.

132 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. Unknown says:

    Thanks for sharing this interesting and useful blog..

    Oracle Training Chennai

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

  4. 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

  5. Bagyaraju says:

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

    Oracle Fusion HCM Online Training

  6. Unknown says:

    Thanks for sharing this blog. I hope you to keep update this kind of blogs.
    Risk management consulting services
    ROI consultant minnesota
    consulting company minnesota

  7. Unknown 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

  8. Unknown says:

    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

  9. 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

  10. 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.

  11. Unknown says:

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

    Java Training in Chennai | Java Training Institute in Chennai

  12. Unknown 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

  13. 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

  14. Unknown 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

  15. Mounika says:

    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

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

    Oracle Fusion Financials Online Training

  17. 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

  18. MOUNIKA says:

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

    Devops Training From India

  19. 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

  20. Mounika 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. 
    python online training
    python training in OMR
    python training course in chennai

  21. Unknown says:

    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

  22. 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

  23. 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

  24. Unknown 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

  25. 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

  26. 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 |

  27. 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


  28. gowthunan says:

    At this time, it seems like Word Press is the preferred blogging platform available right now.
    safety course in chennai

  29. tamilsasi says:

    Resources like the one you mentioned here will be very useful to me ! I will post a link to this page on my blog. I am sure my visitors will find that very useful
    devops online training

    aws online training

    data science with python online training

    data science online training

    rpa online training

  30. sai ram says:

    It would have been the happiest moment for you,I mean if we have been waiting for something to happen and when it happens we forgot all hardwork and wait for getting that happened.
    Microsoft Azure online training
    Selenium online training
    Java online training
    uipath online training
    Python online training

  31. saketh says:


    Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab Python classes in pune your rss feed to stay informed of any updates.

  32. Aman CSE says:



    Such a wonderful blog on Mean Stack .Your blog having almost full information about
    Mean Stack ..Your content covered full topics of Mean Stack ,that it cover from basic to higher level content of Mean Stack .Requesting you to please keep updating the data about Mean Stack in upcoming time if there is some addition.
    Thanks and Regards,
    Best institute for mean stack training in chennai
    Mean stack training fees in Chennai
    Mean stack training institute in Chennai
    Mean stack developer training in chennai
    Mean stack training fees in OMR, Chennai




  33. Anonymous says:

    Very interesting blog Awesome post. your article is really informative
    Oracle Fusion HCM Online Training

  34. Anonymous says:

    Very interesting blog Awesome post. your article is really informative
    Oracle Fusion HCM Online Training

  35. Prwatech says:

    I learned World's Trending Technology from certified experts for free of cost. I Got a job in decent Top MNC Company with handsome 14 LPA salary, I have learned the World's Trending Technology from Data Science Training in btm experts who know advanced concepts which can help to solve any type of Real-time issues in the field of Python. Really worth trying Instant Approval Blog Commenting Sites

  36. Aman CSE says:

    Thanks for sharing such a wonderful blog on Amazon Web Services .
    This blog contains so much data about Amazon Web Services ,like if anyone who is searching for the Amazon Web Services data,They will easily grab the knowledge from this .Requested you to please keep sharing these type of useful content so that other can get benefit from your shared content.
    Thanks and Regards,
    Amazon Web Services training in Chennai
    Best Amazon Web Services training in chennai
    Top Amazon Web Services Training in chennai
    Amazon Web Services training fees in Velachery,Chennai

  37. Anonymous says:

    For Python training in Bangalore, Visit:- Python training in Bangalore

  38. Being new to the blogging world I feel like there is still so much to learn. Your tips helped to clarify a few things for me as well as giving.sap s4 hana simple finance training in bangalore

  39. Linking is very useful thing.you have really helped lots of people who visit blog and provide them use full information.

  40. Wonderful thanks for sharing an amazing idea. keep it...

    Learn Best SAP S4 HANA Simple Finance Training in Bangalore from Experts. Softgen Infotech offers the Best S4 HANA Simple Finance Training in Bangalore.100% Placement Assistance, Live Classroom Sessions, Only Technical Profiles, 24x7 Lab Infrastructure Support.

  41. 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.

    Spark and Scala Online Training
    Spark Scala Training
    Hyderabad

  42. Aman CSE says:

    One of the best content i have found on internet for Azure .Every point for Azure is explained in so detail,So its very easy to catch the content for Azure .keep sharing more contents for Azure and also updating this content for Azure . and keep helping others.
    Cheers !
    Thanks and regards ,
    Azure course in chennai.
    Azure course in Velachery.
    Best Azure course in chennai .
    Top Azure institute in Chennai .

  43. Aman CSE says:

    One of the best content i have found on internet for Azure .Every point for Azure is explained in so detail,So its very easy to catch the content for Azure .keep sharing more contents for Azure and also updating this content for Azure . and keep helping others.
    Cheers !
    Thanks and regards ,
    Azure course in chennai.
    Azure course in Velachery.
    Best Azure course in chennai .
    Top Azure institute in Chennai .

  44. Rishi says:

    Thank you for sharing such this type critical important topic on yoga. We offer an extensive range of Yoga Mats with customization facility.

  45. Ismail says:

    Thank you for sharing such a nice and interesting blog with us...
    Digital Marketing Courses in Bangalore

  46. Joyal says:

    Effective blog with a lot of information. I just Shared you the link below for ACTE .They really provide good level of training and Placement,I just Had Oracle Classes in ACTE , Just Check This Link You can get it more information about the Oracle course.


    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

  47. Devi says:

    Nice blog. thanks for sharing valuable information. oracle training in chennai

  48. This is the exact information I am been searching for, Thanks for sharing the required infos with the clear update and required points.

    AWS Training in Hyderabad





  49. Nice article and thanks for sharing with us. Its very informative


    AI Training in Hyderabad

  50. Lopa says:

    Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.

    Digital Marketing Training in Chennai
    Digital Marketing Training in Bangalore
    Digital Marketing Training in Delhi
    Digital Marketing Online Training

  51. suresh says:

    Good job in presenting the correct content with the clear explanation. The content looks real with valid information. Good Work

    DevOps is currently a popular model currently organizations all over the world moving towards to it. Your post gave a clear idea about knowing the DevOps model and its importance.

    Good to learn about DevOps at this time.

    DevOps Training in Chennai

    DevOps Course in Chennai

  52. suresh 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.
    DevOps Training in Chennai

    DevOps Course in Chennai

  53. Nice to read your article. This has really made good thing
    DOTNET training in bangalore

  54. Devi says:

    Learn Oracle DBA for making your career towards a sky-high with Infycle Technologies. Infycle Technologies provides the top Oracle DBA Training in Chennai and offering programs in Oracle such as Oracle PL/SQL, Oracle Programming, etc., in the 200% hands-on practical training with professional specialists in the field. In addition to that, the interviews will be arranged for the candidates to set their careers without any struggle. Of all that, Cen percent placement assurance will be given here. To have the best job for your life, call 7502633633 to Infycle Technologies and grab a free demo to know more.

    Infycle Technologies
    #85, Medavakkam Main Rd, Rajendra Nagar, Keelkattalai, Chennai, Tamil Nadu 600091

    Top Oracle DBA Training in Chennai

  55. Infycle Technologies, the best software training institute in Chennai offers the No.1 Python Certification in Chennai for tech professionals. Apart from the Python Course, other courses such as Oracle, Java, Hadoop, Selenium, Android, and iOS Development, Big Data will also be trained with 100% hands-on training. After the completion of training, the students will be sent for placement interviews in the core MNC's. Dial 7502633633 to get more info and a free demo.

  56. Anonymous says:

    Thanks for sharing.
    We at Antino Labs believe in redefining and refining our model to suit the industry's requirements. Antino Labs' several years of experience in the market has let us register our global presence. Antino Labs' has the vision to become the world's most trusted partner for digital transformation and we aim to become a brand that defines innovation and the latest technology. We offer clients a one-stop solution for all their interests. Click the below links if you're looking for Web Development Company in Gurgaon, Website Designing Company in Gurgaon, Technology Consulting Services, Ecommerce Account Management Services, Mobile App Development Company in Gurgaonand UI/UX Design Services.

  57. I had a chance to get some useful and unique information.Thank you for sharing....

    Agro Fertilizer Company in India

  58. Roku empowers you to watch free and roku.com/link
    paid video content on your TV by methods for the Internet. For Activating Roku, go to www.roku.com/associate record enter Roku com association code appeared on Roku TV. Initiate Roku tv, go to rokucom link roku.com/link
    record enter Roku.com connection code showed on Roku TV.

    roku.com/link
    roku.com/link
    roku.com/link

  59. Devi says:

    Grab the best AWS Certification training in Chennai from Infycle Technologies, the best software training institute, and Placement centre in Chennai. We also provide technical courses like Power BI, Cyber Security, Graphic Design and Animation, Block Security, Java, Oracle, Python etc. For free demo class and enquiry call 7504633633.

  60. Reshma says:

    This post is so interactive and informative.keep update more information...
    Types of Oracle Database Users
    Different Types of Oracle Database Users

  61. This post is so interactive and informative.keep update more information...
    Ethical Hacking Course in Tambaram
    Ethical Hacking Course in Chennai

  62. Thank you for sharing such beautiful information with us . I hope you will share some more info about FDM is one of the Best Content Marketing Company Services in Chennai. For More Details Call us: 91+ 9791811111 or visit our website.



  63. Anonymous says:

    I am glad it was an enjoyable experience for you.
    wedding photography packages
    leather jacket

  64. I understand this is one of the most significant direction for me. What's more, I'm fiery concentrating on your article. anyway need to analysis upon a few standard matters, the web webpage style is unmodified; the articles are strong. much thanks to you for the significant amount of real and reasonable express.MS Office 2016 With Crack

  65. I have Been addressing pretty much this count number, as a final product gratitude for posting. cold publication.It 's as a matter of fact exceptionally fine and helpful say.thank you Happy Birthday Quotes

Powered by Blogger.

Page Views

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