My Oracle Support Banner

Default Password For System User("manager") Has Changed In Oracle 19c (Doc ID 2620296.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Standard Edition - Version 19.3.0.0.0 and later
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Oracle Database - Personal Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Goal

It is written in "SQL Language Reference" document that:

"CREATE DATABASE"
If you do not specify these clauses, then Oracle Database creates default passwords
change_on_install for user SYS and manager for user SYSTEM.

But default password for system user "manager" has changed in 19c to "no authentication".

  NO AUTHENTICATION Clause

  Use the NO AUTHENTICATION clause to create a schema that does not have a password and cannot
  be logged into. This is intended for schema only accounts and reduces maintenance by removing
  default passwords and any requirement to rotate the password.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.