oracle怎么开启复杂密码验证

本篇内容介绍了“oracle怎么开启复杂密码验证”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！ORACLE 11g开启复杂密码验证SQL> set line 200SQL> SELECT * FROM Dba_Profiles d WHERE d.profile=’DEFAULT’;PROFILE RESOURCE_NAME RESOURCE LIMIT—————————— ——————————– ——– —————————————-DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITEDDEFAULT SESSIONS_PER_USER KERNEL UNLIMITEDDEFAULT CPU_PER_SESSION KERNEL UNLIMITEDDEFAULT CPU_PER_CALL KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITEDDEFAULT IDLE_TIME KERNEL UNLIMITEDDEFAULT CONNECT_TIME KERNEL UNLIMITEDDEFAULT PRIVATE_SGA KERNEL UNLIMITEDDEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10DEFAULT PASSWORD_LIFE_TIME PASSWORD 180PROFILE RESOURCE_NAME RESOURCE LIMIT—————————— ——————————– ——– —————————————-DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITEDDEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULLDEFAULT PASSWORD_LOCK_TIME PASSWORD 1DEFAULT PASSWORD_GRACE_TIME PASSWORD 716 rows selected.注意跑完这个脚本会初始化profile,之前设置的unlimited会变成默认的SQL> @?/rdbms/admin/utlpwdmg.sqlFunction created.Grant succeeded.Profile altered.Function created.Grant succeeded.SQL> SELECT * FROM Dba_Profiles d WHERE d.profile=’DEFAULT’;PROFILE RESOURCE_NAME RESOURCE LIMIT—————————— ——————————– ——– —————————————-DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITEDDEFAULT SESSIONS_PER_USER KERNEL UNLIMITEDDEFAULT CPU_PER_SESSION KERNEL UNLIMITEDDEFAULT CPU_PER_CALL KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITEDDEFAULT IDLE_TIME KERNEL UNLIMITEDDEFAULT CONNECT_TIME 免费主机域名 KERNEL UNLIMITEDDEFAULT PRIVATE_SGA KERNEL UNLIMITEDDEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10DEFAULT PASSWORD_LIFE_TIME PASSWORD 180PROFILE RESOURCE_NAME RESOURCE LIMIT—————————— ——————————– ——– —————————————-DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITEDDEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11GDEFAULT PASSWORD_LOCK_TIME PASSWORD 1DEFAULT PASSWORD_GRACE_TIME PASSWORD 716 rows selected.SQL> alter profile default limit PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION;Profile altered.PROFILE RESOURCE_NAME RESOURCE LIMIT—————————— ——————————– ——– —————————————-DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITEDDEFAULT SESSIONS_PER_USER KERNEL UNLIMITEDDEFAULT CPU_PER_SESSION KERNEL UNLIMITEDDEFAULT CPU_PER_CALL KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITEDDEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITEDDEFAULT IDLE_TIME KERNEL UNLIMITEDDEFAULT CONNECT_TIME KERNEL UNLIMITEDDEFAULT PRIVATE_SGA KERNEL UNLIMITEDDEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10DEFAULT PASSWORD_LIFE_TIME PASSWORD 180PROFILE RESOURCE_NAME RESOURCE LIMIT—————————— ——————————– ——– —————————————-DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITEDDEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITEDDEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTIONDEFAULT PASSWORD_LOCK_TIME PASSWORD 1DEFAULT PASSWORD_GRACE_TIME PASSWORD 716 rows selected.跑完脚本后会创建2个关于密码验证的函数VERIFY_FUNCTION_11G，VERIFY_FUNCTIONORACLE 12C开启复杂密码验证CDB执行SQL> set line 200SQL> col PROFILE for a30SQL> col LIMIT for a30SQL> col RESOURCE_NAME for a30SQL> SELECT * FROM Dba_Profiles d WHERE d.profile=’DEFAULT’;PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP—————————— ——————————– ——– —————————— — — —DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NODEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NODEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NODEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NODEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NODEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NODEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NODEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NODEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NODEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10 NO NO NODEFAULT PASSWORD_LIFE_TIME PASSWORD 180 NO NO NOPROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP—————————— ——————————– ——– —————————— — — —DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NODEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NODEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NODEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NODEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NODEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NOALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION ora12c_verify_function;或者alter profile default limit PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION;需要在PDB执行SQL> alter session set container=PDB1;会话已更改。SQL> set line 200SQL> col PROFILE for a30SQL> col LIMIT for a30SQL> col RESOURCE_NAME for a30SQL> SELECT * FROM Dba_Profiles d WHERE d.profile=’DEFAULT’;PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP—————————— ———————-免费主机域名——– ——– —————————— — — —DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED NO NO NODEFAULT SESSIONS_PER_USER KERNEL UNLIMITED NO NO NODEFAULT CPU_PER_SESSION KERNEL UNLIMITED NO NO NODEFAULT CPU_PER_CALL KERNEL UNLIMITED NO NO NODEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED NO NO NODEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED NO NO NODEFAULT IDLE_TIME KERNEL UNLIMITED NO NO NODEFAULT CONNECT_TIME KERNEL UNLIMITED NO NO NODEFAULT PRIVATE_SGA KERNEL UNLIMITED NO NO NODEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10 NO NO NODEFAULT PASSWORD_LIFE_TIME PASSWORD 180 NO NO NOPROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP—————————— —————————— ——– —————————— — — —DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED NO NO NODEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED NO NO NODEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL NO NO NODEFAULT PASSWORD_LOCK_TIME PASSWORD 1 NO NO NODEFAULT PASSWORD_GRACE_TIME PASSWORD 7 NO NO NODEFAULT INACTIVE_ACCOUNT_TIME PASSWORD UNLIMITED NO NO NO已选择 17 行。SQL> create user test identified by test;用户已创建。SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION ora12c_verify_function;配置文件已更改SQL> alter user test identified by test;alter user test identified by test*第 1 行出现错误:ORA-28003: 指定口令的口令验证失败 ORA-20001:Password length less than 8SQL> alter user test identified by “test123!@#”;alter user test identified by “test123!@#”*第 1 行出现错误:ORA-28003: 指定口令的口令验证失败 ORA-20002:Password contains the usernameSQL> alter profile default limit PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION;配置文件已更改SQL> alter user test identified by “test123!@#” ;用户已更改。“oracle怎么开启复杂密码验证”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注云技术网站，小编将为大家输出更多高质量的实用文章！

相关推荐: spark集群如何使用hanlp进行分布式分词

这篇文章主要介绍“spark集群如何使用hanlp进行分布式分词”，在日常操作中，相信很多人在spark集群如何使用hanlp进行分布式分词问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”spark集群如何使用hanlp进行分布式…