oracle 系統使用者簡介
https://www.cnblogs.com/feiyun8616/p/6497690.html
oracle中的使用者很多,也很令初學者費解.
oracle中的帳戶分為兩類:一類是必需的帳戶,一類是儲存各種應用的帳戶
SCHEMA OVERVIEW
ANONYMOUS
Purpose:
o 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. See also XDB.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catqm.sql
APEX_030200
Purpose:
o Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. The account owns the Application Express schema and metadata. See also APEX_PUBLIC_USER and FLOW_FILES.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/apex/apexins.sql
APEX_PUBLIC_USER
Purpose:
o Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This minimally privileged account is used for Application Express configuration with Oracle HTTP Server and mod_plsql. See also APEX_030200 and FLOW_FILES.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/apex/apexins.sql
APPQOSSYS
Purpose:
o Used for storing/managing all data and metadata required by Oracle Quality of Service Management.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_ADMIN/rdbms/admin/catqos.sql
BI
Purpose:
o The account that owns the Business Intelligence schema included in the Oracle Sample Schemas. See also HR, OE, SH, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/bus_intelligence/bi_main.sql
CTXSYS
Purpose:
o The account used to administer Oracle Text. Oracle Text enables the building of text query applications and document classification applications. It provides indexing, word and theme searching, and viewing capabilities for text.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ctx/admin/ctxsys.sql
DBSNMP
Purpose:
o The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database. Password is created at installation or database creation time.
Safe To Remove:
o Yes – run $ORACLE_HOME/rdbms/admin/catnsnmp.sql
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catsnmp.sql
DIP
Purpose:
o The account used by the Directory Integration Platform. (DIP) to synchronize the changes in Oracle Internet Directory with the applications in the database.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catdip.sql
EXFSYS
Purpose:
o The account used internally to access the EXFSYS schema, which is associated with the Rules Manager and Expression Filter feature. This feature enables the building of complex PL/SQL rules and expressions. The EXFSYS schema contains the Rules Manager and Expression Filter DDL, DML, and associated metadata.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/exfsys.sql
FLOW_FILES
Purpose:
o Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This account owns the Application Express uploaded files. See also APEX_030200 and APEX_PUBLIC_USER.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/apex/apexins.sql
HR
Purpose:
o The account that owns the Human Resources schema included in the Oracle Sample Schemas. See also BI, OE, SH, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/human_resources/hr_main.sql
IX
Purpose:
o The account that owns the Information Transport schema included in the Oracle Sample Schemas. See also BI, HR, OE, SH and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/info_exchange/ix_main.sql
MDDATA
Purpose:
o The schema used by Oracle Spatial for storing Geocoder and router data. See also SPATIAL_CSW_ADMIN_USR , SPATIAL_WFS_ADMIN_USR and MDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/md/admin/catmd.sql
MDSYS
Purpose:
o The Oracle Spatial and Oracle Multimedia Locator administrator account. See also SPATIAL_CSW_ADMIN_USR , MDDATA and SPATIAL_WFS_ADMIN_USR.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
MGMT_VIEW
Purpose:
o An account used by Oracle Enterprise Manager Database Control. Password is randomly generated at installation or database creation time. Users do not need to know this password.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager
OE
Purpose:
o The account that owns the Order Entry schema included in the Oracle Sample Schemas. See also BI, HR, SH, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/ demo/schema/order_entry/oe_main.sql
OLAPSYS
Purpose:
o The account that owns the OLAP Catalog (CWMLite). This account has been deprecated, but is retained for backward compatibility.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/olap/admin/amdsys.sql
ORACLE_OCM
Purpose:
o This account contains the instrumentation for configuration collection used by the Oracle Configuration Manager.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catocm.sql
ORDDATA
Purpose:
o This account contains the Oracle Multimedia DICOM data model.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordisysc.sql
ORDPLUGINS
Purpose:
o 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 also ORDSYS and SI_INFORMTN_SCHEMA.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
ORDSYS
Purpose:
o The Oracle Multimedia administrator account. See also ORDPLUGINS and SI_INFORMTN_SCHEMA.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
OUTLN
Purpose:
o 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.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
OWBSYS
Purpose:
o 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 also OWBSYS_AUDIT.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql
OWBSYS_AUDIT
Purpose:
o This account is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables in the OWBSYS schema.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql
PM
Purpose:
o The account that owns the Product Media schema included in the Oracle Sample Schemas. See also BI, HR, OE, SH and IX.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/product_media/pm_main.sql
SCOTT
Purpose:
o An account used by Oracle sample programs and examples.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/utlsampl.sql
SH
Purpose:
o The account that owns the Sales History schema included in the Oracle Sample Schemas and is only available for Enterprise Edition installations. See also BI, HR, OE, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/sales_history/sh_main.sql
SI_INFORMTN_SCHEMA
Purpose:
o The account that stores the information views for the SQL/MM Still Image Standard. See also ORDPLUGINS and ORDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
SPATIAL_CSW_ADMIN_USR
Purpose:
o The Catalog Services for the Web (CSW) account. It is used by the Oracle Spatial CSW cache manager to load all record type metadata, and record instances from the database into the main memory for the record types that are cached. See also SPATIAL_WFS_ADMIN_USR, MDDATA and MDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/md/admin/sdocswpv.sql
SPATIAL_WFS_ADMIN_USR
Purpose:
o The Web Feature Service (WFS) account. It is used by the Oracle Spatial WFS cache manager to load all feature type metadata, and feature instances from the database into main memory for the feature types that are cached. See also SPATIAL_CSW_ADMIN_USR , MDDATA and MDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/md/admin/sdowfspv.sql
SYS
Purpose:
o An account used to perform. database administration tasks. Password is created at installation or database creation time.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
SYSMAN
Purpose:
o The account used to perform. Oracle Enterprise Manager database administration tasks. The SYS and SYSTEM accounts can also perform. these tasks. Password is created at installation or database creation time.
Safe To Remove:
o Yes
Recreation Script.:
o Created as part of the dbconsole or Enterprise Manager build.
SYSTEM
Purpose:
o 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. Password is created at installation or database creation time.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
WMSYS
Purpose:
o The account used to store the metadata information for Oracle Workspace Manager.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/owmctab.plb
XDB
Purpose:
o The account used for storing Oracle XML DB data and metadata. See also ANONYMOUS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catqm.sql
XS$NULL
Purpose:
o An internal account that represents the absence of a user in a session. Because XS$NULL is not a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULL.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
OTHER ADMINISTRATIVE SCHEMA
The schema listed below are not installed by default, but can be built using the creation script(s) cited and any necessary additional steps as prescribed by the appropriate Oracle manual.
LBACSYS
Purpose:
o The account used to administer Oracle Label Security (OLS). It is created only when the Label Security custom option is installed.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catlbacs.sql
WK_TEST
Purpose:
o The instance administrator for the default instance, WK_INST. After unlocking this account and assigning this user a password, then the cached schema password must also be updated 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 also WKSYS
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ultrasearch/admin/wk0csys.sql
WKSYS
Purpose:
o 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 also WK_TEST
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ultrasearch/admin/wk0csys.sql
WKPROXY
Purpose:
o An administrative account of Application Server Ultra Search.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ultrasearch/admin/wk0csys.sql
oracle中的使用者很多,也很令初學者費解.
oracle中的帳戶分為兩類:一類是必需的帳戶,一類是儲存各種應用的帳戶
預設情況下oracle指對sys,system,dbsnmp,sysman,mgmt_view5個帳戶進行了解鎖,如果希望其它使用者也能登入需要手工進行解鎖
show user 顯示當前登入系統的使用者名稱
select username,account_status,expiry_date from dba_user; 檢視使用者狀態
alter user outln account unlock; 解鎖帳戶
grant connect 帖哦outln identified by 123; 使用者授權
SCHEMA OVERVIEW
ANONYMOUS
Purpose:
o 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. See also XDB.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catqm.sql
APEX_030200
Purpose:
o Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. The account owns the Application Express schema and metadata. See also APEX_PUBLIC_USER and FLOW_FILES.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/apex/apexins.sql
APEX_PUBLIC_USER
Purpose:
o Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This minimally privileged account is used for Application Express configuration with Oracle HTTP Server and mod_plsql. See also APEX_030200 and FLOW_FILES.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/apex/apexins.sql
APPQOSSYS
Purpose:
o Used for storing/managing all data and metadata required by Oracle Quality of Service Management.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_ADMIN/rdbms/admin/catqos.sql
BI
Purpose:
o The account that owns the Business Intelligence schema included in the Oracle Sample Schemas. See also HR, OE, SH, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/bus_intelligence/bi_main.sql
CTXSYS
Purpose:
o The account used to administer Oracle Text. Oracle Text enables the building of text query applications and document classification applications. It provides indexing, word and theme searching, and viewing capabilities for text.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ctx/admin/ctxsys.sql
DBSNMP
Purpose:
o The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database. Password is created at installation or database creation time.
Safe To Remove:
o Yes – run $ORACLE_HOME/rdbms/admin/catnsnmp.sql
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catsnmp.sql
DIP
Purpose:
o The account used by the Directory Integration Platform. (DIP) to synchronize the changes in Oracle Internet Directory with the applications in the database.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catdip.sql
EXFSYS
Purpose:
o The account used internally to access the EXFSYS schema, which is associated with the Rules Manager and Expression Filter feature. This feature enables the building of complex PL/SQL rules and expressions. The EXFSYS schema contains the Rules Manager and Expression Filter DDL, DML, and associated metadata.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/exfsys.sql
FLOW_FILES
Purpose:
o Part of the Oracle Application Express Suite - (Oracle APEX, previously named Oracle HTML DB) which is a freeware software development environment. It allows a fast development cycle to be achieved to create web based applications. This account owns the Application Express uploaded files. See also APEX_030200 and APEX_PUBLIC_USER.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/apex/apexins.sql
HR
Purpose:
o The account that owns the Human Resources schema included in the Oracle Sample Schemas. See also BI, OE, SH, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/human_resources/hr_main.sql
IX
Purpose:
o The account that owns the Information Transport schema included in the Oracle Sample Schemas. See also BI, HR, OE, SH and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/info_exchange/ix_main.sql
MDDATA
Purpose:
o The schema used by Oracle Spatial for storing Geocoder and router data. See also SPATIAL_CSW_ADMIN_USR , SPATIAL_WFS_ADMIN_USR and MDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/md/admin/catmd.sql
MDSYS
Purpose:
o The Oracle Spatial and Oracle Multimedia Locator administrator account. See also SPATIAL_CSW_ADMIN_USR , MDDATA and SPATIAL_WFS_ADMIN_USR.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
MGMT_VIEW
Purpose:
o An account used by Oracle Enterprise Manager Database Control. Password is randomly generated at installation or database creation time. Users do not need to know this password.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/sysman/admin/emdrep/bin/RepManager
OE
Purpose:
o The account that owns the Order Entry schema included in the Oracle Sample Schemas. See also BI, HR, SH, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/ demo/schema/order_entry/oe_main.sql
OLAPSYS
Purpose:
o The account that owns the OLAP Catalog (CWMLite). This account has been deprecated, but is retained for backward compatibility.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/olap/admin/amdsys.sql
ORACLE_OCM
Purpose:
o This account contains the instrumentation for configuration collection used by the Oracle Configuration Manager.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catocm.sql
ORDDATA
Purpose:
o This account contains the Oracle Multimedia DICOM data model.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordisysc.sql
ORDPLUGINS
Purpose:
o 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 also ORDSYS and SI_INFORMTN_SCHEMA.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
ORDSYS
Purpose:
o The Oracle Multimedia administrator account. See also ORDPLUGINS and SI_INFORMTN_SCHEMA.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
OUTLN
Purpose:
o 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.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
OWBSYS
Purpose:
o 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 also OWBSYS_AUDIT.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql
OWBSYS_AUDIT
Purpose:
o This account is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables in the OWBSYS schema.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/owb/UnifiedRepos/cat_owb.sql
PM
Purpose:
o The account that owns the Product Media schema included in the Oracle Sample Schemas. See also BI, HR, OE, SH and IX.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/product_media/pm_main.sql
SCOTT
Purpose:
o An account used by Oracle sample programs and examples.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/utlsampl.sql
SH
Purpose:
o The account that owns the Sales History schema included in the Oracle Sample Schemas and is only available for Enterprise Edition installations. See also BI, HR, OE, IX and PM.
Safe To Remove:
o Yes – run $ORACLE_HOME/demo/schema/drop_sch.sql
Recreation Script.:
o $ORACLE_HOME/demo/schema/sales_history/sh_main.sql
SI_INFORMTN_SCHEMA
Purpose:
o The account that stores the information views for the SQL/MM Still Image Standard. See also ORDPLUGINS and ORDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ord/admin/ordinst.sql
SPATIAL_CSW_ADMIN_USR
Purpose:
o The Catalog Services for the Web (CSW) account. It is used by the Oracle Spatial CSW cache manager to load all record type metadata, and record instances from the database into the main memory for the record types that are cached. See also SPATIAL_WFS_ADMIN_USR, MDDATA and MDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/md/admin/sdocswpv.sql
SPATIAL_WFS_ADMIN_USR
Purpose:
o The Web Feature Service (WFS) account. It is used by the Oracle Spatial WFS cache manager to load all feature type metadata, and feature instances from the database into main memory for the feature types that are cached. See also SPATIAL_CSW_ADMIN_USR , MDDATA and MDSYS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/md/admin/sdowfspv.sql
SYS
Purpose:
o An account used to perform. database administration tasks. Password is created at installation or database creation time.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
SYSMAN
Purpose:
o The account used to perform. Oracle Enterprise Manager database administration tasks. The SYS and SYSTEM accounts can also perform. these tasks. Password is created at installation or database creation time.
Safe To Remove:
o Yes
Recreation Script.:
o Created as part of the dbconsole or Enterprise Manager build.
SYSTEM
Purpose:
o 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. Password is created at installation or database creation time.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
WMSYS
Purpose:
o The account used to store the metadata information for Oracle Workspace Manager.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/owmctab.plb
XDB
Purpose:
o The account used for storing Oracle XML DB data and metadata. See also ANONYMOUS.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catqm.sql
XS$NULL
Purpose:
o An internal account that represents the absence of a user in a session. Because XS$NULL is not a user, this account can only be accessed by the Oracle Database instance. XS$NULL has no privileges and no one can authenticate as XS$NULL, nor can authentication credentials ever be assigned to XS$NULL.
Safe To Remove:
o No
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/sql.bsq. Recover from backup or recreate the database.
OTHER ADMINISTRATIVE SCHEMA
The schema listed below are not installed by default, but can be built using the creation script(s) cited and any necessary additional steps as prescribed by the appropriate Oracle manual.
LBACSYS
Purpose:
o The account used to administer Oracle Label Security (OLS). It is created only when the Label Security custom option is installed.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/rdbms/admin/catlbacs.sql
WK_TEST
Purpose:
o The instance administrator for the default instance, WK_INST. After unlocking this account and assigning this user a password, then the cached schema password must also be updated 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 also WKSYS
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ultrasearch/admin/wk0csys.sql
WKSYS
Purpose:
o 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 also WK_TEST
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ultrasearch/admin/wk0csys.sql
WKPROXY
Purpose:
o An administrative account of Application Server Ultra Search.
Safe To Remove:
o Yes
Recreation Script.:
o $ORACLE_HOME/ultrasearch/admin/wk0csys.sql
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31397003/viewspace-2154521/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle Text簡介Oracle
- Oracle PSU 簡介Oracle
- Oracle：srvctl 簡介Oracle
- Oracle：PGA 簡介Oracle
- 【Android系統】Android系統架構簡介Android架構
- Linux系統管理——Linux簡介Linux
- 一、Linux系統的簡介Linux
- Oracle：RAC 程式簡介Oracle
- Oracle Data Guard簡介Oracle
- Oracle ERP系統排名？什麼是使用者口碑最好的Oracle ERP系統？Oracle
- 【Oracle體系結構】 Oracle19C 系統結構介紹Oracle
- Slack系統架構簡介 - jinlow架構
- 鴻蒙系統freeModbusTcp移植簡介鴻蒙TCP
- Oracle的service功能簡介Oracle
- 2.5.1. Oracle net簡介Oracle
- Oracle PL/SQL塊簡介OracleSQL
- 作業系統-第一章-系統簡介作業系統
- 分散式跟蹤系統zipkin簡介分散式
- Nagios+Centreon監控系統簡介iOS
- web伺服器管理系統簡介Web伺服器
- Oracle RAC簡介與要點Oracle
- Oracle OCP(50)：審計簡介Oracle
- Oracle：容器資料庫簡介Oracle資料庫
- 【檔案系統】嵌入式檔案系統Fatfs簡介
- Django之簡易使用者系統(3)Django
- 助力Java系統元件化：Navi框架簡介Java元件化框架
- 學會Zynq（7）中斷系統簡介
- 《推薦系統實踐》筆記 01 推薦系統簡介筆記
- 根檔案系統簡介與BusyBox構建根檔案系統
- Android初級之路-Android系統架構簡介Android架構
- DB2--資料庫管理系統簡介DB2資料庫
- centos7系統執行級別簡介CentOS
- 學舟圖書閱讀管理系統簡介
- 《Kettle構建Hadoop ETL系統實踐》簡介Hadoop
- SQL Server 2008事件處理系統簡介LSSQLServer事件
- 雲伺服器linux系統的程式簡介伺服器Linux
- Oracle - 資料庫的組成簡介Oracle資料庫
- 簡單介紹oracle重置序列的方法Oracle