Re: 10G passwords in Oracle 12C

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 9 Jul 2018 14:54:13 -0400

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

Other related posts: