LLI Wiki — My Digital Knowledge Base

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

Mastodon LLIMastodon SocialFosstodon