Re: 10G passwords in Oracle 12C
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 9 Jul 2018 14:54:13 -0400
Message-ID: <298a8cbf-9d06-1a87-862a-a61b4dbafb6b_at_gmail.com>
Date: Mon, 9 Jul 2018 14:54:13 -0400
Message-ID: <298a8cbf-9d06-1a87-862a-a61b4dbafb6b_at_gmail.com>
The password field of DBA_USERS is not populated since 11G. You can find the password hashes in SYS.USER$ table.
On 07/09/2018 01:37 PM, 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?
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 09 2018 - 20:54:13 CEST