重庆思庄Oracle、Redhat认证学习论坛
标题: ORACLE自带用户都是干嘛的呀 [打印本页]
作者: 郑全 时间: 2016-5-10 21:03
标题: ORACLE自带用户都是干嘛的呀
oracle安装好后,自带了很多用户,比如:
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
HR
OUTLN
FLOWS_FILES
MDSYS
ORDSYS
EXFSYS
WMSYS
APPQOSSYS
APEX_030200
OWBSYS_AUDIT
ORDDATA
CTXSYS
ANONYMOUS
XDB
ORDPLUGINS
OWBSYS
SI_INFORMTN_SCHEMA
OLAPSYS
SCOTT
ORACLE_OCM
XS$NULL
BI
PM
MDDATA
IX
SH
DIP
OE
APEX_PUBLIC_USER
SPATIAL_CSW_ADMIN_USR
SPATIAL_WFS_ADMIN_USR
那么这些用户到底是干什么的,我怕误人子弟,翻了一下联机文档,还是看看他们的解释吧:
Table 3-1 Predefined Oracle Database Administrative User Accounts
User Account
Description
Status After Installation
ANONYMOUS
Account that allows HTTP access to Oracle XML DB. It is used in place of the APEX_PUBLIC_USER account when the Embedded PL/SQL Gateway (EPG) is installed in the database.
EPG is a Web server that can be used with Oracle Database. It provides the necessary infrastructure to create dynamic applications.
Expired and locked
CTXSYS
The account used to administer Oracle Text. Oracle Text enables you to build text query applications and document classification applications. It provides indexing, word and theme searching, and viewing capabilities for text.
See
Oracle Text Application Developer's Guide.
Expired and locked
DBSNMP
Open
Password is created at installation or database creation time.
EXFSYS
The account used internally to access the EXFSYS schema, which is associated with the Rules Manager and Expression Filter feature. This feature enables you to build complex PL/SQL rules and expressions. The EXFSYS schema contains the Rules Manager and Expression Filter DDL, DML, and associated metadata.
See
Oracle Database Rules Manager and Expression Filter Developer's Guide.
Expired and locked
LBACSYS
Expired and locked
MDSYS
Expired and locked
MGMT_VIEW
An account used by Oracle Enterprise Manager Database Control.
Open
Password is randomly generated at installation or database creation time. Users do not need to know this password.
OLAPSYS
The account that owns the OLAP Catalog (CWMLite). This account has been deprecated, but is retained for backward compatibility.
Expired and locked
ORDDATA
This account contains the Oracle Multimedia DICOM data model. See Oracle Multimedia DICOM Developer's Guide for more information.
Expired and locked
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.
See
Oracle Warehouse Builder Installation and Administration Guide.
Expired and locked
ORDPLUGINS
The Oracle Multimedia user. Plug-ins supplied by Oracle and third-party, format plug-ins are installed in this schema.
Oracle Multimedia enables Oracle Database to store, manage, and retrieve images, audio, video, DICOM format medical images and other objects, or other heterogeneous media data integrated with other enterprise information.
See
Oracle Multimedia User's Guide and
Oracle Multimedia Reference.
Expired and locked
ORDSYS
Expired and locked
OUTLN
The account that supports plan stability. Plan stability prevents certain database environment changes from affecting the performance characteristics of applications by preserving execution plans in stored outlines. OUTLN acts as a role to centrally manage metadata associated with stored outlines.
See
Oracle Database Performance Tuning Guide.
Expired and locked
SI_INFORMTN_SCHEMA
Expired and locked
SYS
Open
Password is created at installation or database creation time.
SYSMAN
Open
Password is created at installation or database creation time.
SYSTEM
A default generic database administrator account for Oracle databases.
For production systems, Oracle recommends creating individual database administrator accounts and not using the generic SYSTEM account for database administration operations.
See
Oracle Database 2 Day DBA.
Open
Password is created at installation or database creation time.
WK_TEST
The instance administrator for the default instance, WK_INST. After you unlock this account and assign this user a password, then you must also update the cached schema password using the administration tool Edit Instance Page.
Ultra Search provides uniform search-and-location capabilities over multiple repositories, such as Oracle databases, other ODBC compliant databases, IMAP mail servers, HTML documents managed by a Web server, files on disk, and more.
See
Oracle Ultra Search Administrator's Guide.
Expired and locked
WKSYS
An Ultra Search database super-user. WKSYS can grant super-user privileges to other users, such as WK_TEST. All Oracle Ultra Search database objects are installed in the WKSYS schema.
See
Oracle Ultra Search Administrator's Guide.
Expired and locked
WKPROXY
Expired and locked
WMSYS
Expired and locked
XDB
The account used for storing Oracle XML DB data and metadata.
Oracle XML DB provides high-performance XML storage and retrieval for Oracle Database data.
See
Oracle XML DB Developer's Guide.
Expired and locked
作者: 邓辉 时间: 2016-5-11 09:00
好文,学习了
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) |
Powered by Discuz! X3.2 |