Duplicate users in CDB
(Doc ID 2871879.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterInformation 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 |