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.

11 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

Powered by Blogger.

Page Views

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