通过覆盖密码策略更改蟾蜍中的密码

Question

我想更改蟾蜍中的密码，但是我想保留一个不符合密码策略设置的密码。在更改密码时，如何覆盖密码策略？

Answer 1

找到用户的配置文件 -

SQL> select profile from dba_users where username='USER1';
PROFILE
--------------------------------------------------------------------------------
DEFAULT

然后更改配置文件以将password_verify_function设置为null。

SQL> conn sys as sysdba

SQL> alter user user1 identified by user1;
alter user user1 identified by user1
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20026: Password must contain at least 1 special character(s)

SQL> alter profile default limit password_verify_function null;
Profile altered.
SQL> alter user c##_user1 identified by user1;
User altered.