Shulou(Shulou.com)05/31 Report--

Editor to share with you how ORACLE can achieve at least 8 characters and contain at least three of the four types of letters, special characters, numbers, uppercase and lowercase. I hope you will get something after reading this article. Let's discuss it together.

Use the utlpwdmg.sql script that comes with ORACLE to implement

Operation method

1. Create table proflileYYYYMMDD as select * from dba_profiles where profile='DEFAULT'

2. Back up a copy of $ORACLE_HOME/rdbms/admin/utlpwdmg.sql first

3. Modify utlpwdmg.sql,ALTER to keep only verify_function_11G, and delete other PASSWORD_LIFE_TIME, PASSWORD_GRACE_TIME, PASSWORD_REUSE_TIME, PASSWORD_REUSE_MAX, FAILED_LOGIN_ATTEMPTS and PASSWORD_LOCK_TIME.

Only the following red font content is retained

ALTER PROFILE DEFAULT LIMIT

PASSWORD_VERIFY_FUNCTION verify_function_11G

The original content is as follows

ALTER PROFILE DEFAULT LIMIT

PASSWORD_LIFE_TIME 180

PASSWORD_GRACE_TIME 7

PASSWORD_REUSE_TIME UNLIMITED

PASSWORD_REUSE_MAX UNLIMITED

FAILED_LOGIN_ATTEMPTS 10

PASSWORD_LOCK_TIME 1

PASSWORD_VERIFY_FUNCTION verify_function_11G

4. Compare the following results

Select * from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION'

Select * from proflileYYYYMMDD where RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION'

192.168.8.7 user interface

SQL > select * from proflile20181219 where RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION'

PROFILE RESOURCE_NAME RESOURCE LIMIT

DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL

SQL > @ utlpwdmg.sql

Function created.

Grant succeeded.

Profile altered.

Function created.

Grant succeeded.

SQL > select * from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION'

PROFILE RESOURCE_NAME RESOURCE LIMIT

DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G

After reading this article, I believe you have a certain understanding of "how ORACLE implements a password of at least 8 digits and contains at least three of the four types of letters, special characters, numbers, uppercase and lowercase". If you want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.