Oracle: default database accounts, purpose and removal
Reference of the accounts created by default in an Oracle database (SYS, SYSTEM, XDB, SCOTT...), their purpose, the creating script and whether they can be dropped.
An Oracle database contains many accounts created by the installation, by optional components or by demo scripts. This memo lists what each one is for, which script creates it and whether it can be dropped; handy for a security audit or a clean-up before going to production. The historical default passwords of these accounts are well known: always change them, or lock or drop the account.
System accounts to keep
| Account | Purpose | Notes |
|---|---|---|
| SYS | Owner of the data dictionary | Created by sql.bsq and the cat*.sql scripts; password can be changed, cannot be dropped |
| SYSTEM | Default DBA account (avoid using SYS for daily work) | Created by sql.bsq; password can be changed, cannot be dropped |
| OUTLN | Stored outlines for optimizer plan stability | Created by sql.bsq; cannot be dropped |
| APPQOSSYS | Quality of Service Management | Must not be removed |
Accounts tied to optional components
| Account | Purpose | Creation / removal |
|---|---|---|
| ANONYMOUS | PL/SQL gateway letting a web browser call a stored procedure over HTTP | catqm.sql; can be dropped if XDB is not used through a browser |
| XDB | Owner of XML DB objects | catqm.sql; can be removed with catnoqm.sql if XDB is no longer used |
| CTXSYS | Oracle Text / interMedia (ConText) administrator | dr0csys.sql |
| DBSNMP | Intelligent Agent / monitoring | catsnmp.sql; if changed, update the password in snmp_rw.ora too; can be dropped if the agent is not used |
| DIP | Processing of Directory Integration and Provisioning events | catdip.sql; can be removed with dbca if DIP is no longer used |
| EXFSYS | Dictionary and APIs for the Expression Filter | exfsys.sql; can be removed with catnoexf.sql |
| LBACSYS | Owner of Oracle Label Security (OLS) | catlbacs.sql; can be removed with catnools.sql if OLS is no longer used |
| MDSYS | Oracle Spatial administrator | ordinst.sql |
| MDDATA | Spatial schema for geocoder and router data | |
| ORDSYS, ORDPLUGINS | Object Relational Data (ORD) users, time series, etc. | ordinst.sql |
| ORDDATA | Schema for DICOM imaging objects | |
| OLAPSYS | OLAP | |
| DMSYS | Data Mining | odmcrt.sql; can be dropped with DROP USER ... CASCADE |
| TSMSYS | Transparent Session Migration (Grid feature) | cattsm.sql; can be dropped with DROP USER ... CASCADE |
| DSSYS | Oracle Dynamic Services and Syndication Server | dssys_init.sql |
| ORACLE_OCM | Owner of Oracle Configuration Manager packages | catocm.sql; created locked with an expired password |
| FLOWS_FILES | Apex | |
| AURORA$ORB$UNAUTHENTICATED | Unauthenticated users of Aurora/ORB | init_orb.sql |
| PERFSTAT | STATSPACK package (supersedes UTLBSTAT/UTLESTAT) | statscre.sql |
| TRACESVR | Oracle Trace server | otrcsvr.sql |
Temporary utility accounts
| Account | Purpose | Notes |
|---|---|---|
| AWR_STAGE | Loads data into AWR from a dump file | awrload.sql; must be dropped to use that script |
| CSMIG | Database Character Set Migration Utility | csminst.sql; the password is given when calling the script; dropped and recreated on each run |
Demo accounts to drop in production
| Account | Content | Created by |
|---|---|---|
| SCOTT (and ADAMS, JONES, CLARK, BLAKE) | Sample EMP and DEPT tables | utlsampl.sql |
| HR, OE, SH | Sample schemas (Human Resources, Order Entry, Sales History) | mksample.sql |
| DEMO | Oracle Data Browser demonstration | demo.sql |
Drop them with DROP USER <account> CASCADE;.
Notes
- The original table describes an old Oracle release (9i/10g); the accounts present depend on the version and installed options. Check with
SELECT username, account_status FROM dba_users;. - Historical default passwords are deliberately not reproduced here.