Google+ Followers

Pages

Friday, July 27, 2012

Known schemas in Oracle


This is a (most probably unfinished) list of users  that come with an Oracle installation or with installing the Oracle sample schemas For most of these users, the default password is the same as the username. Where this is not the case, I have noted it.
ANONYMOUS
Used for HTTP access to XML DB.
APEX_PUBLIC_USER
APEX_030200
APPQOSSYS
BI
This user is created with the oracle sample schemas. It owns the Business Intelligenceschema.
CTXSYS
The owner of Oracle text (formerly: interMedia text).
DBSNMP
Part of the Oracle intelligent agent.
The password is assigned during the installation.
This user is created (or re-created) with ORACLE_HOME/rdbms/admin/catsnmp.sql and dropped with $ORACLE_HOME/rdbms/admin/catnsnmp.sql.
DIP
Used by the Directory Integration Platform (DIP) which synchronizes changes in the Oracle Internet Directory with applications in the database.
DMSYS
This user is used for Data Mining.
EXFSYS
This schema is used for expression filters.
FLOWS_XXXXXX
This seems to be the user for APEX (Oracle Application Express) (on Oracle Express Edition???). XXXXXX seems to be the version number of APEX. So, APEX 2.1 hasflows_020100.
HR
Installed with Oracle sample schemas. It owns the Human Resource schema.
IX
Installed with Oracle sample schemas. It owns the Information Transport schema.
LBACSYS
The administration account for Oracle Label Security.
MDDATA
Used by Oracle Spatial to store Geocoder and router data.
MDSYS
The owner of spatial (which is a part of interMedia).
MGMT_VIEW
Used for the Oracle Enterprise Manager Database Control.
Its password is generated randomly.
ODM
The Data mining schema. Since Oracle 10g, the name can be freely chosen.
ODM_MTR
Used for the data repository for data mining samples.
Default password: mtrpw.
OE
Installed with Oracle sample schemas. It owns the Order Entry schema.
OLAPSYS
The schema that owns the OLAP catalogs.
Default password: manager.
ORACLE_OCM
ORDDATA
ORDPLUGINS
Like mdsys: part of interMedia. Third party plugins (as well as Oracle plugins) for interMedia are installed into this schema.
ORDSYS
The administration account for interMedia.
OUTLN
Used for the query plan stability feature.
outln owns ol$ol$hints and ol$nodes.
PM
Installed with Oracle sample schemas. It owns the Product Media schema.
SCOTT
Used for Oracle examples.
Its default password is tiger.
This schema is created by executing $ORACLE_HOME/sqlplus/demo/demobld.sql(demodrop.sql drops scott.)
SH
Installed with Oracle sample schemas. It owns the Sales History schema.
SI_INFORMTN_SCHEMA
Used for SQL/MM Still Image Standard.
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
SYS
Used for database administration. See this link.
The password is set when the database is installed.
SYSMAN
The default super user account used to set up and administer enterprise manager.
The password is set when the database is installed.
SYSTEM
Used for database administration. See this link.
The password is set when the database is installed.
TRACESRV
Used for Oracle trace. Not used anymore since Oracle 8.
MTSSYS
Used for Microsoft transaction server support.
OASPUBLIC
OLAPSYS
Used for OLAP.
OWBSYS
OWBSYS_AUDIT
WEBSYS
WK_PROXY
Used for ultrasearch.
Default password: wksys.
WKSYS
Used for ultrasearch.
Default password: wmsys.
WK_TEST
WMSYS
The owner for Workspace Manager.
XDB
Used for XML DB.
OSE$HTTP$ADMIN
AURORA$JIS$UTILITY$
AURORA$ORB$UNAUTHENTICATED

No comments:

Post a Comment