首页 / ORACLE / oracle中的用户详解 【转】
oracle中的用户详解 【转】
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了oracle中的用户详解 【转】,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含8974字,纯文字阅读大概需要13分钟。
内容图文
![oracle中的用户详解 【转】](/upload/InfoBanner/zyjiaocheng/524/bb80b6529d8d45969265b316f7639d3e.jpg)
http://f.dataguru.cn/thread-128531-1-1.html
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
内容总结
以上是互联网集市为您收集整理的oracle中的用户详解 【转】全部内容,希望文章能够帮你解决oracle中的用户详解 【转】所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。