My Oracle Support Banner

Duplicate users in CDB (Doc ID 2871879.1)

Last updated on APRIL 17, 2023

Applies to:

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

Goal

There are many duplicate users in the CDB.

SQL> col username for a30
SQL> set pagesize 0
SQL> set linesize 1024
SQL> set colsep ,
SQL> select con_id,username,account_status,created,common from cdb_users order by username;

        3,TEST                               ,OPEN                            ,03-APR-19,NO
        7,TEST                               ,OPEN                            ,03-APR-19,NO
        3,TEST2                             ,OPEN                            ,04-APR-19,NO
        7,TEST2                             ,OPEN                            ,04-APR-19,NO
        7,ANONYMOUS                     ,EXPIRED & LOCKED                ,07-MAY-14,YES
        4,ANONYMOUS                     ,EXPIRED & LOCKED                ,19-APR-19,YES
        3,ANONYMOUS                     ,EXPIRED & LOCKED                ,07-MAY-14,YES
        1,ANONYMOUS                     ,EXPIRED & LOCKED                ,19-APR-19,YES
        1,AUDSYS                          ,LOCKED                          ,19-APR-19,YES
        3,AUDSYS                          ,LOCKED                          ,06-OCT-15,YES
        4,AUDSYS                          ,LOCKED                          ,19-APR-19,YES
        7,AUDSYS                          ,LOCKED                          ,06-OCT-15,YES
 

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.