Re: 10G passwords in Oracle 12C

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Mon, 09 Jul 2018 14:59:15 -0500
Message-ID: <c5bf0dd373a77661cc06e35be7c17d9e_at_society.servebeer.com>

On 2018/07/09 12:37, Jeffrey Beckstrom wrote:

> After upgrading to Oracle 12C, we found that we have some old user accounts with only 10 specified for the password_version value in sys.dba_users. Short of requiring the users to changes these passwords, is there any way to continue to allow these passwords to function with 12C?

Specifically, which version of Oracle 12? And are you getting an error message trying to login as those users? Here's what I get (username obviously changed):

SQL> SELECT username
FROM dba_users
WHERE password_versions = '10G ' -- note the trailing space ORDER BY username;

USERNAME

---

_[snip]_
MYOLDUSER 7 rows selected.

SQL> connect myolduser
Enter password:
Connected.
SQL> select user from dual;

USER

---

MYOLDUSER SQL> select * from v$version;

BANNER                                                                  
            CON_ID
--------------------------------------------------------------------------------

---

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Production              0
PL/SQL Release 12.1.0.2.0 - Production                                  
                 0
CORE    12.1.0.2.0      Production                                      
                         0
TNS for IBM/AIX RISC System/6000: Version 12.1.0.2.0 - Production       
                 0
NLSRTL Version 12.1.0.2.0 - Production                                  
                 0

I've been using this in test for about 8 months now with no issue, which your question now has me curious...

Rich

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jul 09 2018 - 21:59:15 CEST