Talk:List of default database users

From Oracle FAQ
Jump to: navigation, search

There are a few users missing from this list. I've included links to various Oracle manuals that describe the schemas.

Oracle APEX:

Each version creates a schema with an "APEX_" prefix, followed by the version number (earlier versions used the "FLOWS_" prefix). To date the versions have been:

FLOWS_010500
FLOWS_010600
FLOWS_020000
FLOWS_020100
FLOWS_020200
FLOWS_030000
FLOWS_030100
APEX_030200
APEX_040000
APEX_040100
APEX_040200
APEX_050000

Oracle REST Data Services :

APEX_PUBLIC_USER
APEX_REST_PUBLIC_USER
APEX_LISTENER
ORDS_METADATA
ORDS_PUBLIC_USER

Oracle Multimedia:

ORDDATA
SI_INFORMTN_SCHEMA

Other default users:

APPQOSSYS
AUDSYS
BI
DVF
DVSYS
FLOWS_FILES
GSMADMIN_INTERNAL
GSMCATUSER
GSMUSER
IX
OE
ORACLE_OCM
PM
SH
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
SYSDG
SYSKM
WMSYS

A few more default users:

MDDATA
OLAPSYS
SYSMAN