PASSWORD not available from oracle 11g in DBA_USERS view
ALTER USER IDENTIFIED BY VALUES with Oracle 11g Oracle 11g introduces case-sensitive passwords for databases created with the default Oracle Database 11g enhanced security. With the new initialization parameter SEC_CASE_SENTITIVE_LOGON, it’s possible to enable or disable password case sensitivity in the database. The default value of this parameter is TRUE: SQL> SELECT value FROM v$parameter WHERE name = ‘sec_case_sensitive_logon’; VALUE ————— TRUE When we issue a CREATE/ALTER USER IDENTIFIED BY PASSWORD command, both the insensitive and the sensitive password hashes are saved (but the user’s password is sensitive). The two hashes are stored in the SYS.USER$ view (not into the DBA_USERS view): SQL> CREATE USER anilve IDENTIFIED BY anilve; User created. SQL> GRANT connect, resource TO anilve; Grant succeeded. SQL> CONNECT anilve/Anilve ERROR: ORA-01017: invalid username/password; logon denied Warning: You are no longer connected to ORACLE. SQL> CONNECT an...