以下是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. |
