oracle 各版本預設使用者
以下是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. |
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. |
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. |
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle預設使用者Oracle
- Oracle預設使用者介紹Oracle
- Oracle___專題研究__Oracle預設使用者Oracle
- oracle的預設使用者清單Oracle
- 查詢oracle各元件的版本Oracle元件
- ORACLE資料庫各個版本PATCHOracle資料庫
- oracle10g 預設使用者說明Oracle
- ORACLE各個版本系統安裝需求Oracle
- Oracle的預設使用者及其建立指令碼[轉]Oracle指令碼
- Oracle使用者預設表空間的問題Oracle
- oracle BI工具的預設使用者和密碼Oracle密碼
- 設定maven預設的jdk版本MavenJDK
- 各個Oracle 版本下如何調整高水位(HWM)Oracle
- Chartboost:iOS系統各個版本使用者分佈情況iOS
- MySQL 不同版本預設字符集MySql
- Oracle 預設埠列表Oracle
- Linux各種版本Linux
- NUnit 的各個版本
- Oracle 低版本匯入高版本按使用者expdp/impdpOracle
- Oracle各種版本下“示例資料庫的建立”的建立Oracle資料庫
- Mac 切換預設 PHP 版本為 MAMPMacPHP
- CentOS 6升級預設python版本CentOSPython
- 寶塔皮膚切換預設PHP版本PHP
- MyEclipse - 修改Maven預設的Jdk版本EclipseMavenJDK
- 修改Python預設的執行版本Python
- 預設使用者和密碼密碼
- Oracle 修改預設日期格式Oracle
- eclipse 建立maven專案設定預設jdk版本EclipseMavenJDK
- jquery各個版本下載jQuery
- MySQL各個版本區別MySql
- Android 各個版本WebViewAndroidWebView
- oracle 當前資料庫各種版本時間釋出表Oracle資料庫
- Oracle9i,10g,11g 預設使用者統計Oracle
- Oracle11g修改預設使用者密碼有效期時間Oracle密碼
- ORACLE8i/9i 預設安裝所建立的使用者:Oracle
- ubuntu系統存在兩個PHP版本,預設版本的坑壞人UbuntuPHP
- Oracle EBS R12.1 版本各種開啟及關閉操作Oracle
- Oracle系統預設的稽核Oracle