Oracle 9iR2 預設帳號


幾年前,剛開始接手維護DB時,會計師提出有關DB帳號太多的疑問。
那是因為之前維護的人員在安裝Oracle 9iR2時,一併選擇建立預設資料庫,
並且以預設的資料庫當做正式資料庫來使用,以致於有許多的帳號,
於是上網找了一下資料,把找到的帳號用途記錄一下。
當然這些我們沒有使用的帳號都是停用的。
後來我在更換DB伺服器時,重裝Oracle 9iR2就不再預先建立資料庫。帳號也只留有需要的。



帳號
說明
DB預設
使用狀態
SYS
Oracle系統帳號(DBA)
SYSTEM
Oracle系統帳號(DBA)
DBSNMP
Used by Management Agent of Oracle Enterprise Manager to monitor and manage the database. This account is created only if you configure the database to use Database Control.
ERPAPP
自行創建,ERP系統開發用帳號
SCOTT
An account used by Oracle sample programs and examples
APPS001
自行創建,ERP系統開發用帳號
OUTLN
CONNECTRESOURCE角色的帳號
WMSYS
The account used to store the metadata information for Oracle Workspace Manager.
ORDSYS
The Oracle interMedia Audio, Video, Locator, and Image administrator account.
ORDPLUGINS
Centrally manages metadata associated with stored outlines. Supports plan stability, which enables maintenance of the same execution plans for the same SQL statements.
MDSYS
Spatial administrator user
CTXSYS
Oracle Text模式,全文索引
XDB
Used for storing Oracle XML DB data and metadata.
ANONYMOUS
Allows HTTP access to Oracle XML DB
ODM
Oracle Disk Manager
ODM_MTR
Oracle Disk Manager
WKPROXY
代理服務器帳號
QS_ADM
EXAMPLE USER
HR
Owns the Human Resources schema included in the Oracle Sample Schemas. It is available only if you loaded the Sample Schemas.
OE
Owns the Order Entry schema included in the Oracle Sample Schemas. This account is available only if you loaded the Sample Schemas.
PM
Owns the Product Media schema included in the Oracle Sample Schemas. This account is created only if you loaded the Sample Schemas.
SH
Used for storing Oracle XML DB data and metadata.
RMAN
RMAN備份用帳號(DB Backup)
QS
EXAMPLE USER
QS_WS
EXAMPLE USER (Western Shipping)
QS_ES
EXAMPLE USER
QS_OS
EXAMPLE USER (Overseas Shipping)
QS_CBADM
EXAMPLE USER
QS_CB
EXAMPLE USER (Customer Billing)
QS_CS
EXAMPLE USER (Customer Service)