In the Oracle11g database, dba_users has the password_versions column while oracle11gdba_users
Reference:
11g R1 New Feature: Case Sensitive Passwords and Strong User Authentication (Document 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.
In reference, the PASSWORD_VERSIONS column is described as follows:
Database version in which the password was created or changed
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.