使用預設配置建立資料庫後，我們透過dba_users檢視可以查到資料庫中的所有使用者資訊，除了我們熟知的sys、system使用者外，還有為數眾多的其他使用者。預設情況下oracle指對sys,system,dbsnmp,sysman,mgmt_view5個帳戶進行了解鎖,如果希望其它使用者也能登入需要手工進行解鎖。那麼，這麼多使用者都是用來做什麼的呢。

點選(此處)摺疊或開啟

SQL>
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL>
SQL>
SQL> select username,account_status,created from dba_users;
USERNAME ACCOUNT_STATUS CREATED
------------------------------ -------------------------------- ---------
SYS OPEN 18-SEP-11
SYSTEM OPEN 18-SEP-11
OUTLN EXPIRED & LOCKED 18-SEP-11
MGMT_VIEW EXPIRED & LOCKED 18-SEP-11
FLOWS_FILES EXPIRED & LOCKED 18-SEP-11
MDSYS EXPIRED & LOCKED 18-SEP-11
ORDSYS EXPIRED & LOCKED 18-SEP-11
EXFSYS EXPIRED & LOCKED 18-SEP-11
DBSNMP EXPIRED & LOCKED 18-SEP-11
WMSYS EXPIRED & LOCKED 18-SEP-11
APPQOSSYS EXPIRED & LOCKED 18-SEP-11
APEX_030200 EXPIRED & LOCKED 18-SEP-11
OWBSYS_AUDIT EXPIRED & LOCKED 18-SEP-11
ORDDATA EXPIRED & LOCKED 18-SEP-11
CTXSYS EXPIRED & LOCKED 18-SEP-11
ANONYMOUS EXPIRED & LOCKED 18-SEP-11
SYSMAN EXPIRED & LOCKED 18-SEP-11
XDB EXPIRED & LOCKED 18-SEP-11
ORDPLUGINS EXPIRED & LOCKED 18-SEP-11
OWBSYS EXPIRED & LOCKED 18-SEP-11
SI_INFORMTN_SCHEMA EXPIRED & LOCKED 18-SEP-11
OLAPSYS EXPIRED & LOCKED 18-SEP-11
SCOTT EXPIRED & LOCKED 18-SEP-11
ORACLE_OCM EXPIRED & LOCKED 18-SEP-11
XS$NULL EXPIRED & LOCKED 18-SEP-11
BI EXPIRED & LOCKED 13-OCT-14
PM EXPIRED & LOCKED 13-OCT-14
MDDATA EXPIRED & LOCKED 18-SEP-11
IX EXPIRED & LOCKED 13-OCT-14
SH EXPIRED & LOCKED 13-OCT-14
DIP EXPIRED & LOCKED 18-SEP-11
OE EXPIRED & LOCKED 13-OCT-14
APEX_PUBLIC_USER EXPIRED & LOCKED 18-SEP-11
HR EXPIRED & LOCKED 13-OCT-14
SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED 18-SEP-11
SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 18-SEP-11
36 rows selected.
SQL>

sys/change_on_InstaLL or InternaL

系統使用者，資料字典所有者，超級許可權所有者(SYSDBA)

建立指令碼：?/rdbms/admin/SQL.bsq and various cat*.SQL

建議建立後立即修改密碼，此使用者不能被刪除

system/manager

資料庫預設管理使用者，擁有DBA角色許可權

建立指令碼：?/rdbms/admin/SQL.bsq

建議建立後立即修改密碼，此使用者不能被刪除

outLn/outLn

最佳化計劃的儲存大綱使用者

建立指令碼：?/rdbms/admin/SQL.bsq

建議建立後立即修改密碼，此使用者不能被刪除

MGMT_VIEW

MGMT_VIEW 使用者數DB Control Repository的一部分，和SYSMAN使用者一起構成DB Control Repository的組成部分。
MGMT_VIEW 不擁有任何物件，僅用於查詢 SYSMAN 使用者物件

FLOWS_FILES

是Oracle Application Express的系統賬號，該賬戶擁有oracle application express上傳的檔案。

MDSYS/MDSYS

MDSYS是ORACLE的空間資料（spatial）和媒介（interMedia）、音訊（audio）、影片（Vidio）及圖象的管理員使用者名稱。

ORDSYS/ORDSYS

ORDSYS是ORACLE InterMedia Audio Video Locator 和Image的使用者名稱。它有CONNECT和RESOURCE角色。

EXFSYS/EXFSYS

表示式過濾器使用者

dbsnmp/dbsnmp

目錄整合平臺使用者，DBSNMP包括CONNECT,RESOURCEHE SNMPAGENT資料庫角色。

建立指令碼：?/rdbms/admin/catsnmp.SQL, called from catalog.SQL

可以改變密碼--需要放置新密碼到snmp_rw.ora檔案

如果不需要Intelligent agents，可以刪除該使用者。

WMSYS/WMSYS

工作空間管理帳戶

appqossys

Used for storing/managing all data and metadata required by Oracle Quality of Service Management.

apex030200

APEX產品資料庫使用者，其中ORACLE 的資訊生命週期管理工具ILMA的使用前提是Apex。

owbsys_audit

This account is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables in the schema.

orddata

This account contains the Oracle Multimedia DICOM data model.

ctxsys

interMedia Text使用者

anonymous

用來訪問ORACLE XML DB知識庫的賬戶。

SYSMAN/OEM_TEMP

企業管理器帳戶

XDB/CHANGE_ON_INSTALL

xml db帳戶

ORDPLUGINS

The Oracle interMedia user. Plug-ins supplied by Oracle and third party format plug-ins are installed in this schema.

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.

SI_INFORMTN_SCHEMA

靜止影像標準瀏覽帳戶(The account that stores the information views for the SQL/MM Still Image Standard)

OLAPSYS

用於建立OLAP後設資料的使用者。包括OLAP_DBA\RESOURCE\CONNECT角色

scott/tiger

實驗、測試使用者，含有例表emp與dept

建立指令碼：?/rdbms/admin/utlsampl.SQL

可以修改密碼,使用者可以被刪除，在產品環境建議刪除或鎖定

ORACLE_OCM

Oracle 預定義的非管理員使用者

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

BI

The account that owns the Business Intelligence schema included in the Oracle Sample Schemas.

PM

- The account that owns the Product Media schema included in the Oracle Sample Schemas.

- 建立指令碼：$ORACLE_HOME/demo/schema/product_media/pm_main.sql

MDDATA

The schema used by Oracle Spatial for storing Geocoder and router data.

IX

The account that owns the Information Transport schema included in the Oracle Sample Schemas.

The account that owns the Information Transport schema included in the Oracle Sample Schemas

sh/sh (sales history)

實驗、測試使用者，含有例表products、sales、customers等

可以修改密碼,使用者可以被刪除，在產品環境建議刪除或鎖定

DIP

目錄整合平臺的帳戶（DIRECTORY INTEGERATION PLATFORM)

OE

示例使用者。

HR/HR

實驗、測試使用者，含有例表empLoyees與departments

建立指令碼：?/demo/schema/mksample.SQL

可以修改密碼,使用者可以被刪除，在產品環境建議刪除或鎖定

SPATIAL_CSW_ADMIN_USR

The Catalog Services for the Web (CSW) account. It is used by the 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. See also , and .

SPATIAL_WFS_ADMIN_USR

The Web Feature Service (WFS) account. It is used by the 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. See also , and .

參考文件
%20%E2%80%8Bspatial_csw_admin_usr&issp=1&f=8&ie=utf-8&tn=baiduhome_pg&inputT=14065&oq=oracle%20anony

Oracle預設使用者介紹