USERNAME

Definition

SYS

The SYS user is created with the database as the highest level user and owns all oracle base objects within the Oracle RDBMS.   By default the SYS is the only user in the RDBMS which has the SYSDBA privilege and can perform any task within the database.

SYSTEM

The SYSTEM user is created with the database but does not have sysdba privileges by default.   This account is meant for administrative use that does not require total RDBMS control.

OUTLN

The account that supports plan stability. Plan stability prevents certain database environment changes from affecting the performance characteristics of applications by preserving execution plans in stored outlines. OUTLN acts as a role to centrally manage metadata associated with stored outlines.

DIP

The Oracle Directory Integration and Provisioning (DIP) account that is installed with Oracle Label Security. This profile is created automatically as part of the installation process for Oracle Internet Directory-enabled Oracle Label Security.

ORACLE_OCM

The account used with Oracle Configuration Manager. This feature enables you to associate the configuration information for the current Oracle Database instance with OracleMetaLink. Then when you log a service request, it is associated with the database instance configuration information.

APPQOSSYS

The APPQASSYS account manages and owns all objects for Oracle Quality of Service Management.

WMSYS

The account used to store the metadata information for Oracle Workspace Manager.

EXFSYS

The account used internally to access the EXFSYS schema, which is associated with the Rules Manager and Expression Filter feature. This feature enables you to build complex PL/SQL rules and expressions. The EXFSYS schema contains the Rules Manager and Expression Filter DDL, DML, and associated metadata.

CTXSYS

The account used to administer Oracle Text. Oracle Text enables you to build text query applications and document classification applications. It provides indexing, word and theme searching, and viewing capabilities for text.

XDB

The account used for storing Oracle XML DB data and metadata.  Oracle XML DB provides high-performance XML storage and retrieval for Oracle Database data.

ANONYMOUS

Account that allows HTTP access to Oracle XML DB. It is used in place of the APEX_PUBLIC_USER account when the Embedded PL/SQL Gateway (EPG) is installed in the database.  EPG is a Web server that can be used with Oracle Database. It provides the necessary infrastructure to create dynamic applications.

XS$NULL

An internal account that represents the absence of a user in a session. Because XS$NULL is not a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULL.

ORDPLUGINS

The Oracle Multimedia user. Plug-ins supplied by Oracle and third-party, format plug-ins are installed in this schema.  Oracle Multimedia enables Oracle Database to store, manage, and retrieve images, audio, video, DICOM format medical images and other objects, or other heterogeneous media data integrated with other enterprise information.

MDSYS

The Oracle Spatial and Oracle Multimedia Locator administrator account.

ORDDATA

The ORDDATA account owns the Oracle Mulimedia DICOM data modal.

ORDSYS

The Oracle Multimedia administrator account.

SI_INFORMTN_SCHEMA

The account that stores the information views for the SQL/MM Still Image Standard.

OLAPSYS

The account that owns the OLAP Catalog (CWMLite). This account has been deprecated, but is retained for backward compatibility.

MDDATA

The schema used by Oracle Spatial for storing Geocoder and router data.  Oracle Spatial provides a SQL schema and functions that enable you to store, retrieve, update, and query collections of spatial features in an Oracle database.

SPATIAL_WFS_ADMIN_USR

The Web Feature Service (WFS) account. It is used by Oracle Spatial WFS Cache Manager to load all feature type metadata and feature instances from the database into main memory for the feature types that are cached.

SPATIAL_CSW_ADMIN_USR

The Catalog Services for the Web (CSW) account. It is used by Oracle Spatial CSW Cache Manager to load all record-type metadata and record instances from the database into the main memory for the record types that are cached.

SYSMAN

The account used to perform Oracle Enterprise Manager database administration tasks. The SYS and SYSTEM accounts can also perform these tasks.

MGMT_VIEW

An account used by Oracle Enterprise Manager Database Control.

OWBSYS

The account for administrating the Oracle Warehouse Builder repository.  Access this account during the installation process to define the base language of the repository and to define Warehouse Builder workspaces and users. A data warehouse is a relational or multidimensional database that is designed for query and analysis.

OWBSYS_AUDIT

The account is used by Warehouse builder to access the audit tables of OWBSYS.

DBSNMP

The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database.