oracle 各版本預設使用者

zy_rain發表於2023-12-16

以下是oracle11,12,19 預定義預設使用者列表:

  oracle   11.2

oracle 12.2

oracle 19c

ANONYMOUS

CTXSYS

DBSNMP

EXFSYS

LBACSYS

MDSYS

MGMT_VIEW

OLAPSYS

ORDDATA

OWBSYS

ORDPLUGINS

ORDSYS

OUTLN

SI_INFORMTN_SCHEMA

SYS

SYSMAN

SYSTEM

WK_TEST

WKSYS

WKPROXY

WMSYS

XDB

APEX_PUBLIC_USER

DIP

FLOWS_040100

FLOWS_FILES

MDDATA

ORACLE_OCM

SPATIAL_CSW_ADMIN_USR

SPATIAL_WFS_ADMIN_USR

XS$NULL

HR

OE

PM

IX

SH

ANONYMOUS

AUDSYS

CTXSYS

DBSNMP

LBACSYS

MDSYS

OLAPSYS

ORDDATA

ORDPLUGINS

ORDSYS

SI_INFORMTN_SCHEMA

SYS

SYSBACKUP

SYSDG

SYSKM

SYSRAC

SYSTEM

WMSYS

XDB

DIP

MDDATA

ORACLE_OCM

SPATIAL_CSW_ADMIN_USR

SPATIAL_WFS_ADMIN_USR

XS$NULL

HR

OE

PM

IX

SH

ANONYMOUS

APPQOSSYS

AUDSYS

CTXSYS

DBSNMP

DBSFWUSER

DVF

DVSYS

GGSYS

GSMADMIN_INTERNAL

GSMCATUSER

GSMROOTUSER

GSMUSER

LBACSYS

MDSYS

OJVMSYS

OLAPSYS

ORDDATA

ORDPLUGINS

ORDSYS

OUTLN

REMOTE_SCHEDULER_AGENT

SI_INFORMTN_SCHEMA

SYS

SYS$UMF

SYSBACKUP

SYSDG

SYSKM

SYSRAC

SYSTEM

WMSYS

XDB

DIP

MDDATA

ORACLE_OCM

XS$NULL

HR

OE

PM

IX

SH

以下是oracle 19c 預定義預設使用者描述,每個使用者的作用以及部分對應的文件資訊:

 User Account

Description

ANONYMOUS

An   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.

APPQOSSYS

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

AUDSYS

The   internal account used by the unified audit feature to store unified audit   trail records.

See .

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 .

DBSNMP

The   account used by the Management Agent component of Oracle Enterprise Manager   to monitor and manage the database.

See .

DBSFWUSER

The   account used to run the DBMS_SFW_ACL_ADMIN package.

See .

DVF

The   account owned by Oracle Database Vault that contains public functions to   retrieve Database Vault factor values.

See

DVSYS

Oracle   Database Vault account that is associated with the DV_OWNER (for   administrative configurations) and DV_ACCTMGR (for account management) roles.

See

GGSYS

The   internal account used by Oracle GoldenGate. It should not be unlocked or used   for a database login.

See

GSMADMIN_INTERNAL

The   internal account that owns the Global Data Services schema. It should not be   unlocked or used for a database login.

See

GSMCATUSER

The   account used by Global Service Manager to connect to the Global Data Services   catalog.

See

GSMROOTUSER

An   account that is used to log into CDB$ROOT for CDBs in a sharding   configuration. This user is not used in GDS configurations. Any connections   to CDB$ROOT in a CDB are with GSMROOTUSER.

GSMUSER

The   account used by Global Service Manager to connect to the database.

See

LBACSYS

The   account used to administer Oracle Label Security (OLS). It is created only   when you install the Label Security custom option.

See Oracle   Label Security Administrator’s Guide.

MDSYS

The   Oracle Spatial and Oracle Multimedia Locator administrator account.

See .

OJVMSYS

The   account that is used with the Java Naming and Directory Interface (JNDI)   support with Oracle JVM support. This account owns database tables that store   the following details about JVM objects: namespace metadata, bound names,   attributes, permissions, and stored object representations.

See .

OLAPSYS

The   account that owns the OLAP Catalog (CWMLite). This account has been   deprecated, but is retained for backward compatibility.

ORDDATA

This account contains the Oracle Multimedia DICOM data   model. See for more   information.

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 .

ORDSYS

The   Oracle Multimedia administrator account.

See .

OUTLN

The   account that supports plan stability. Plan stability enables you to maintain   the same execution plans for the same SQL statements. OUTLN acts as a role to   centrally manage metadata associated with stored outlines.

REMOTE_SCHEDULER_AGENT

The   account to disable remote jobs on a database. This account is created during   the remote scheduler agent configuration. You can disable the capability of a   database to run remote jobs by dropping this user.

See .

SI_INFORMTN_SCHEMA

The   account that stores the information views for the SQL/MM Still Image   Standard.

See .

Note:   The SI_INFORMTN_SCHEMA account is deprecated in Oracle Database 12c release 2   (12.2).

SYS

An   account used to perform database administration tasks.

See .

SYS$UMF

The   account used to administer Remote Management Framework, including the remote   Automatic Workload Repository (AWR).

See .

SYSBACKUP

The   account used to perform Oracle Recovery Manager recovery and backup   operations.

See .

SYSDG

The   account used to perform Oracle Data Guard operations.

See .

SYSKM

The   account used to manage Transparent Data Encryption.

See Oracle   Database Advanced Security Guide.

SYSRAC

The   account used to manage Oracle Real Application Clusters.

See .

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 .

WMSYS

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

See .

XDB

The   account used for storing Oracle XML DB data and metadata. For better   security, never unlock the XDB user account.

Oracle   XML DB provides high-performance XML storage and retrieval for Oracle   Database data.

See .

DIP

The   Oracle Directory Integration and Provisioning (DIP) account that is installed   with Oracle Label Security. This profile is created automatically as part of   the installation process for Oracle Internet Directory-enabled Oracle Label   Security.

See Oracle   Label Security Administrator’s Guide.

MDDATA

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

Oracle   Spatial provides a SQL schema and functions that enable you to store,   retrieve, update, and query collections of spatial features in an Oracle   database.

See .

ORACLE_OCM

The   account used with Oracle Configuration Manager. This feature enables you to   associate the configuration information for the current Oracle Database   instance with My Oracle Support. Then when you log a service request, it is   associated with the database instance configuration information.

See   Oracle Database Installation Guide for your platform.

XS$NULL

An   internal account that represents the absence of database user in a session   and the actual session user is an application user supported by Oracle Real   Application Security. XS$NULL has no privileges and does not own any database   object. No one can authenticate as XS$NULL, nor can authentication   credentials ever be assigned to XS$NULL.

HR

The   account used to manage the HR (Human Resources) schema. This schema stores   information about the employees and the facilities of the company.

OE

The   account used to manage the OE (Order Entry) schema. This schema stores   product inventories and sales of the company's products through various   channels.

PM

The   account used to manage the PM (Product Media) schema. This schema contains   descriptions and detailed information about each product sold by the company.

IX

The   account used to manage the IX (Information Exchange) schema. This schema   manages shipping through business-to-business (B2B) applications.

SH

The   account used to manage the SH (Sales) schema. This schema stores business   statistics to facilitate business decisions.


來自 “ ITPUB部落格 ” ,連結:https://blog.itpub.net/30349701/viewspace-3000379/,如需轉載,請註明出處,否則將追究法律責任。

相關文章