Oracle Default User in Oracle 12c erkennen

12c

Seit Oracle 12c kann über die VIEW DBA_USERS geprüft werden, welche Oracle Schemas von Oracle selber beim Anlegen der DB für Features in der DB erzeugt wurden.

Aus der Doku: 

ORACLE_MAINTAINED VARCHAR2(1)
	  	
Denotes whether the user was created, and is maintained, by Oracle-supplied scripts (such as catalog.sql or catproc.sql). A user for which this column has the value Y must not be changed in any way except by running an Oracle-supplied script.

Beispiel: 

SELECT COUNT(*)
      , oracle_maintained 
  FROM dba_users 
 GROUP BY rollup (oracle_maintained)
/
 
    COUNT(*) ORA
------------ ---
          12 N
          39 Y
 
          51

Quellen

Oracle:

Web: