19c后的用户密码在user$的列SPARE4中加密，而在dba_users的password里为空

最新推荐文章于 2022-01-09 11:16:49 发布

好记忆不如烂笔头abc

最新推荐文章于 2022-01-09 11:16:49 发布

阅读量1.5k

点赞数

分类专栏： oracle19c oracle12c

本文链接：https://blog.csdn.net/jycjyc/article/details/110535888

版权

oracle19c 同时被 2 个专栏收录

171 篇文章 6 订阅

订阅专栏

oracle12c

81 篇文章 0 订阅

订阅专栏

19c后的用户密码在user$的列SPARE4中加密，而在dba_users的password里为空，每次修改hash值都会变化，即使相同密码值也不同。

SQL> alter user test1 identified by 888;

User altered.

SQL> select SPARE4 from user$ where name='test1';

SPARE4
--------------------------------------------------------------------------------
S:D178F599351B90F310CEDCE66D9E29FECD9EE5ADEE7F6B481547E53D262D;T:F2BF99315471324
A627007AC6DAC099346D6243A49212474FAE699531D7FA1E2CBF29F8593726D3AF702EDE21C11940
C9CBF5820CF3F7DF8AA6C921530EC9B910F22845314F124EDE7914DFED9EA4688

SQL> alter user test1 identified by 1;

User altered.

SQL> select SPARE4 from user$ where name='test1';

SPARE4
--------------------------------------------------------------------------------
S:9312A0F93E6AC168B8C674E4E9C4538DCB8506E98578842F2788178D7233;T:09CAC3EECF38CF2
6CB4C2391B464A4AF1F1F9A1CF392AA767FFE7E19E491B2B8D32CB1BB4F7BAA5FDCB1832974A3FB3
EB579D44F427249E20818E4F543DE8E5E459695EB1B2828186C970045DDEC92D0

SQL> grant dba to test1;

Grant succeeded.

SQL> conn test1/1@dbcenter
Connected.
SQL> conn test/888@dbcenter
Connected.
SQL> alter user test1 IDENTIFIED BY VALUES 'S:D178F599351B90F310CEDCE66D9E29FECD9EE5ADEE7F6B481547E53D262D;T:F2BF99315471324A627007AC6DAC099346D6243A49212474FAE699531D7FA1E2CBF29F8593726D3AF702EDE21C11940C9CBF5820CF3F7DF8AA6C921530EC9B910F22845314F124EDE7914DFED9EA4688';

User altered.

SQL> conn test1/1@dbcenter
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn test1/888@dbcenter
Connected.
SQL>