2007年03月12日 21:34

查到10g預設的系統帳號說明

最近在看一些文件,突然oracle為何要預設一些帳號呢
上網查了一下資料,發現每個都有他的用意
為了以後方便查尋,小記一下

來源:http://download-uk.oracle.com/docs/cd/B19306_01/install.102/b14316/startrdb.htm

Table 5-1 Administrative Accounts

User Name Description See Also

ANONYMOUS

Allows HTTP access to Oracle XML DB.

Not applicable

BI

Owns the Business Intelligence schema included in the Oracle Sample Schemas. It is only available if you loaded the Sample Schemas.

Oracle Database Sample Schemas


CTXSYS

The Oracle Text account.

Oracle Text Reference


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.

Oracle Enterprise Manager Grid Control Installation and Basic Configuration


DIP

Used by Directory Integration Platform (DIP) to synchronize the changes in Oracle Internet Directory with the applications in the database.

Oracle Internet Directory Administrator's Guide


DMSYS

Performs data mining operations.

Oracle Data Mining Administrator's Guide


EXFSYS

Owns the Expression Filter schema.

None

HR

Owns the Human Resources schema included in the Oracle Sample Schemas. It is available only if you loaded the Sample Schemas.

Oracle Database Sample Schemas


IX

Owns the Information Transport schema included in the Oracle Sample Schemas. This account is available only if you loaded the Sample Schemas.

Oracle Database Sample Schemas


LBACSYS

The Oracle Label Security administrator account.

Oracle Label Security Administrator's Guide

MDDATA

Used by Oracle Spatial for storing Geocoder and router data.

Oracle Spatial User's Guide and Reference


MDSYS

The Oracle Spatial and Oracle Locator administrator account.

Oracle Spatial User's Guide and Reference

MGMT_VIEW

Used by Oracle Enterprise Manager Database Control.

None

OE

Owns the Order Entry schema included in the Oracle Sample Schemas. This account is available only if you loaded the Sample Schemas.

Oracle Database Sample Schemas


OLAPSYS

Owns the OLAP catalogs

Oracle OLAP Application Developer's Guide

ORDPLUGINS

The Oracle interMedia Audio and Video account. Plug-ins supplied by Oracle and third party plug-ins are installed in this schema.

Oracle interMedia Reference


ORDSYS

The Oracle interMedia Audio, Video, Locator, and Image administrator account.

Oracle interMedia Reference


OUTLN

Centrally manages metadata associated with stored outlines. Supports plan stability, which enables maintenance of the same execution plans for the same SQL statements.

Oracle Database Performance Tuning Guide


PM

Owns the Product Media schema included in the Oracle Sample Schemas. This account is created only if you loaded the Sample Schemas.

Oracle Database Sample Schemas


SCOTT

An account used by Oracle sample programs and examples.

Oracle Database Administrator's Guide

SH

Owns the Sales History schema included in the Oracle Sample Schemas. This account is available only if you loaded the Sample Schemas during an Enterprise Edition installation

Oracle Database Sample Schemas


SI_INFORMTN_SCHEMA

Stores the information views for the SQL/MM Still Image Standard.

Oracle interMedia Reference


SYS

Used for performing database administration tasks.

Oracle Database Administrator's Guide

SYSMAN

The account used to perform Oracle Enterprise Manager database administration tasks.This account is created only if you configure the database to use the Database Control.

Oracle Enterprise Manager Grid Control Installation and Basic Configuration


SYSTEM

Used for performing database administration tasks.

Oracle Database Administrator's Guide

WMSYS

The account used to store the metadata information for Oracle Workspace Manager.

Oracle Database Application Developer's Guide - Workspace Manager


XDB

Used for storing Oracle XML DB data and metadata.

Oracle XML DB Developer's Guide




這裏有簡單的說明sys跟sysoper的差別
http://www.cuddletech.com/articles/oracle/node34.html

The big diffrence between SYSDBA and SYSOPER privs is that SYSDBA can do anything (just like root). The SYSOPER privs allow you just about the same amount of control but won't allow you to look at user data. Both privs allow you to ALTER DATABASE, CREATE SPFILE, STARTUP or SHUTDOWN, ALTER DATABASE ARCHIVELOG, and includes RESTRICTED SESSION privs. However, only SYSDBA can CREATE or DROP DATABASE, and the ALTER DATABASE RECOVER options for SYSOPER are limited to complete recovery only.

  • my_work 發表於樂多回應(0)引用(0)DB編輯本文
    樂多分類:網路/3C │昨日人次:2 │累計人次:1001
    Ads by Roodo! 

    引用URL

    http://cgi.blog.roodo.com/trackback/2844101