How does ORACLE implement a password of at least 8 digits and contain at least three of the four types of letters, special characters, numbers, uppercase and lowercase
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!
