close

幾年前,剛開始接手維護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)

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 keven 的頭像
    keven

    平凡的幸福(備站)

    keven 發表在 痞客邦 留言(0) 人氣()