首页 > 代码库 > Oracle 默认用户汇总
Oracle 默认用户汇总
Oracle帐户有两种：
必须的帐户，如SYS/SYSTEM/SYSMAN等
存储各种应用的帐户；
| 用户 | 口令 | 说明 |
| ANONYMOUS | ANONYMOUS | 用于访问ORACLEXMLDB知识库的帐户。 |
| CTXSYS | CTXSYS | interMedia Text用户，有CONNECT\RESOURCE\DBA权限 |
| DIP | DIP | 目录集成平台的帐户（DIRECTORYINTEGERATIONPLATFORM) |
| DBSNMP | DBSNMP | 目录集成平台用户，DBSNMP包括CONNECT,RESOURCEHE SNMPAGENT数据库角色。 创建脚本：?/rdbms/admin/catsnmp.SQL, called from catalog.SQL 可以改变密码--需要放置新密码到snmp_rw.ora文件 如果不需要Intelligent agents，可以删除该用户。 |
| DMSYS | DMSYS | |
| EXFSYS | EXFSYS | 表达式过滤器帐户（EXPRESSIOFILTER) |
| MDDATA | MDDATA | ORACLE空间数据帐户 |
| MDSYS | MDSYS | 空间数据（SPATIAL)\媒介（INTERMEDIA)\音频（AUDIO)\视频（VIDEO)和图像管理员帐户。它有CONNECT和RESOURCE角色。 |
| MGMT_VIEW | MGMT_VIEW | MGMT_VIEW 用户是DB Control Repository的一部分，和SYSMAN用户一起构成DB Control Repository的组成部分。 MGMT_VIEW 不拥有任何对象，仅用于查询 SYSMAN 用户对象 |
| OLAPSYS | MANAGER | 用于创建OLAP元数据的用户。包括OLAP_DBA\RESOURCE\CONNECT角色 |
| ORDPLUGINS | ORDPLUGINS | ORACLE INTERMEDIA和VIDEO的用户名，有CONNECT和RESURCE角色，与第三方连接 |
| ORDSYS | ORDSYS | ORACLEINTERMEDIA和VIDEO的用户名，有CONNECT和RESOURCE角色 |
| OUTLN | OUTLN | 有CONNECT和RESOURCE角色 |
| SCOTT | Tiger | 简单的样例帐户 |
| SI_INFORMTN_SCHEMA | 静止图像标准浏览帐户 | |
| SYS | 安装时确定 | 执行数据库的管理任务，实例的数据字典都在SYS下 |
| SYSMAN | OEM_TEMP | 企业管理器帐户 |
| SYSTEM | 安装时确定 | 用于执行数据库管理任务，有少量的实例对象 |
| WK_TEST | WK_TEXT | 管理ORACLE10gULTRASEARCH的帐户，和WKSYS有一样的作用 |
| WKPROXY | 未知 | ORACLE10g与代理服务器有关的帐户 |
| WKSYS | WKSYS | 管理ORACLE10gASULTRASEARCH帐户，与WK_TEST有一样的作用 |
| WMSYS | WMSYS | 工作空间管理帐户 |
| XDB | CHANGE_ON_INSTALL | XMLDB帐户 |
| TSMSYS | Oracle 10g的所有目录上的特点及与此相关的观点/表的新特征是储存在TSMSYS用户下 | |
| oracle_ocm | Oracle 预定义的非管理员用户 | |
| FLOWS_FILES | 是Oracle Application Express的系统账号，该账户拥有oracle application express上传的文件。 | |
| appqossys | Used for storing/managing all data and metadata required by Oracle Quality of Service Management. | |
| apex030200 | APEX产品数据库用户，其中ORACLE 的信息生命周期管理工具ILMA的使用前提是Apex。 | |
| owbsys_audit | This account is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables in the OWBSYS schema. | |
| orddata | This account contains the Oracle Multimedia DICOM data model. | |
| OWBSYS | 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. | |
| XS$NULL | 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 | |
| BI | The account that owns the Business Intelligence schema included in the Oracle Sample Schemas. | |
| PM | The account that owns the Product Media schema included in the Oracle Sample Schemas. | |
| IX | The account that owns the Information Transport schema included in the Oracle Sample Schemas. | |
| sh | 实验、测试用户，含有例表products、sales、customers等 可以修改密码,用户可以被删除，在产品环境建议删除或锁定 | |
| OE | 示例用户 | |
| HR | 实验、测试用户，含有例表empLoyees与departments | |
| SPATIAL_CSW_ADMIN_USR | 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. | |
| SPATIAL_WFS_ADMIN_USR | 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. |
本文出自 “DBA Fighting!” 博客，请务必保留此出处http://hbxztc.blog.51cto.com/1587495/1878925
Oracle 默认用户汇总
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。