My Oracle Support Banner

Common Users Are Not Being Created in PDBs (Doc ID 2867094.1)

Last updated on OCTOBER 09, 2023

Applies to:

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


NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner. 

A common user C##<name> is created in the CDB using the statement below. The common user does not show up in any PDB as it should. When querying CDB_USERS from the CDB, or querying DBA_USERS from the PDB, no rows for common user names are returned for any of the PDBs.

A 10046 trace of the user creation does not show any errors.




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

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