用于字符集更改的CSSCAN，数据库版本11.2.0.3.0
用于字符集更改的CSSCAN，数据库版本11.2.0.3.0
提问于 2019-11-25 10:21:06
根据745809.1文件，安装Csscan。
在运行"Csminst.sql“时，我们会遇到以下错误
SQL> @$ORACLE_HOME/rdbms/admin/csminst.sql
create user csmig identified by csmig password expire account lock
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed回答 1
Database Administration用户
发布于 2019-11-25 19:59:14
只需编辑至少8个字符的脚本，其中至少包括1位数字。
或2禁用密码验证功能。
下面是第二个禁用密码验证功能的方法
SQL> select * from dba_profiles
2 where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION';
PROFILE RESOURCE_NAME RESOURCE LIMIT
-------------------------------------------------- -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G
"
SQL> @csminst
create user csmig identified by csmig password expire account lock
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password length less than 8
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
/*-- Disable password verify function temporarily-- */
SQL> alter profile default LIMIT PASSWORD_VERIFY_FUNCTION NULL;
Profile altered.
SQL> @csminst
User created.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
User altered.
0 rows created.
1 row updated.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
Table created.
Synonym dropped.
Synonym created.
18 rows created.
View created.
Synonym dropped.
Synonym created.
View created.
Synonym dropped.
Synonym created.
View created.
Synonym dropped.
Synonym created.
View created.
Synonym dropped.
Synonym created.
View created.
Synonym dropped.
Synonym created.
View created.
Synonym dropped.
Synonym created.
View created.
View created.
View created.
View created.
Grant succeeded.
Grant succeeded.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
SQL> select username from dba_users
2 where created > sysdate-1;
USERNAME
------------------------------
CSMIG
SQL> select * from dba_profiles
2 where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
/* Enabling Password Verify function --*/
SQL> alter profile default LIMIT PASSWORD_VERIFY_FUNCTION VERIFY_FUNCTION_11G;
Profile altered.
SQL> select * from dba_profiles
2 where profile='DEFAULT' and resource_name='PASSWORD_VERIFY_FUNCTION';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_FUNCTION_11G
/*-- Run a simple test to check password verify function enabled-- */
SQL> create user test identified by test;
create user test identified by test
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20001: Password length less than 8页面原文内容由Database Administration提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://dba.stackexchange.com/questions/254060
复制相关文章
相似问题
腾讯云开发者
