Oracle11g数据库中dba_users多了password_versions这一列

最新推荐文章于 2024-08-02 18:26:57 发布

原创最新推荐文章于 2024-08-02 18:26:57 发布 · 3.3k 阅读

0 ·

CC 4.0 BY-SA版权

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文介绍Oracle 11g数据库中新引入的DBA_USERS视图中的PASSWORD_VERSIONS列，该列用于记录密码创建或更改的数据库版本。通过此列可以判断用户的密码是否已更新为新的哈希值，以及如何实现密码大小写敏感。

参考自：
11g R1 New Feature : Case Sensitive Passwords and Strong User Authentication (文档 ID 429465.1)

The view DBA_USERS has new column PASSWORD_VERSIONS rendered as follows:

decode(length(u.password),16,'10G ',NULL)||NVL2(u.spare4, '11G ' ,NULL)
for example:

SQL> select USERNAME, PASSWORD_VERSIONS from dba_users;

USERNAME PASSWORD
------------------------------ --------
...
SCOTT 10G 11G

In this case it means both old and new-style hash values ar available for user SCOTT, the new hash value is stored in the USER$.SPARE4 column, as long as this remains NULL it means the password has not been changed since the migration and the user will have the old case insensitive password. If you want to enforce case sensitivity for users changing their passwords using a profile with a password_verify_function, check Note 1307555.1 for how to do this.

在reference中，PASSWORD_VERSIONS 列的解释如下：
Database version in which the password was created or changed