ITPub博客

首页 > 数据库 > Oracle > Oracle默认用户介绍

Oracle默认用户介绍

Oracle 作者:bitifi 时间:2015-09-22 12:45:41 0 删除 编辑
        使用默认配置创建数据库后,我们通过dba_users视图可以查到数据库中的所有用户信息,除了我们熟知的sys、system用户外,还有为数众多的其他用户。默认情况下oracle指对sys,system,dbsnmp,sysman,mgmt_view5个帐户进行了解锁,如果希望其它用户也能登录需要手工进行解锁。那么,这么多用户都是用来做什么的呢。

点击(此处)折叠或打开

  1. SQL>
  2. SQL> select * from v$version;

  3. BANNER
  4. --------------------------------------------------------------------------------
  5. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
  6. PL/SQL Release 11.2.0.3.0 - Production
  7. CORE 11.2.0.3.0 Production
  8. TNS for Linux: Version 11.2.0.3.0 - Production
  9. NLSRTL Version 11.2.0.3.0 - Production

  10. SQL>
  11. SQL>
  12. SQL> select username,account_status,created from dba_users;

  13. USERNAME ACCOUNT_STATUS CREATED
  14. ------------------------------ -------------------------------- ---------
  15. SYS OPEN 18-SEP-11
  16. SYSTEM OPEN 18-SEP-11
  17. OUTLN EXPIRED & LOCKED 18-SEP-11
  18. MGMT_VIEW EXPIRED & LOCKED 18-SEP-11
  19. FLOWS_FILES EXPIRED & LOCKED 18-SEP-11
  20. MDSYS EXPIRED & LOCKED 18-SEP-11
  21. ORDSYS EXPIRED & LOCKED 18-SEP-11
  22. EXFSYS EXPIRED & LOCKED 18-SEP-11
  23. DBSNMP EXPIRED & LOCKED 18-SEP-11
  24. WMSYS EXPIRED & LOCKED 18-SEP-11
  25. APPQOSSYS EXPIRED & LOCKED 18-SEP-11
  26. APEX_030200 EXPIRED & LOCKED 18-SEP-11
  27. OWBSYS_AUDIT EXPIRED & LOCKED 18-SEP-11
  28. ORDDATA EXPIRED & LOCKED 18-SEP-11
  29. CTXSYS EXPIRED & LOCKED 18-SEP-11
  30. ANONYMOUS EXPIRED & LOCKED 18-SEP-11
  31. SYSMAN EXPIRED & LOCKED 18-SEP-11
  32. XDB EXPIRED & LOCKED 18-SEP-11
  33. ORDPLUGINS EXPIRED & LOCKED 18-SEP-11
  34. OWBSYS EXPIRED & LOCKED 18-SEP-11
  35. SI_INFORMTN_SCHEMA EXPIRED & LOCKED 18-SEP-11
  36. OLAPSYS EXPIRED & LOCKED 18-SEP-11
  37. SCOTT EXPIRED & LOCKED 18-SEP-11
  38. ORACLE_OCM EXPIRED & LOCKED 18-SEP-11
  39. XS$NULL EXPIRED & LOCKED 18-SEP-11
  40. BI EXPIRED & LOCKED 13-OCT-14
  41. PM EXPIRED & LOCKED 13-OCT-14
  42. MDDATA EXPIRED & LOCKED 18-SEP-11
  43. IX EXPIRED & LOCKED 13-OCT-14
  44. SH EXPIRED & LOCKED 13-OCT-14
  45. DIP EXPIRED & LOCKED 18-SEP-11
  46. OE EXPIRED & LOCKED 13-OCT-14
  47. APEX_PUBLIC_USER EXPIRED & LOCKED 18-SEP-11
  48. HR EXPIRED & LOCKED 13-OCT-14
  49. SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED 18-SEP-11
  50. SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 18-SEP-11

  51. 36 rows selected.

  52. SQL>

sys/change_on_InstaLL or InternaL

系统用户,数据字典所有者,超级权限所有者(SYSDBA)

创建脚本:?/rdbms/admin/SQL.bsq and various cat*.SQL

建议创建后立即修改密码,此用户不能被删除

 system/manager

数据库默认管理用户,拥有DBA角色权限

创建脚本:?/rdbms/admin/SQL.bsq

建议创建后立即修改密码,此用户不能被删除

 outLn/outLn

优化计划的存储大纲用户

创建脚本:?/rdbms/admin/SQL.bsq

建议创建后立即修改密码,此用户不能被删除

MGMT_VIEW

MGMT_VIEW 用户数DB Control Repository的一部分,和SYSMAN用户一起构成DB Control Repository的组成部分。
MGMT_VIEW 不拥有任何对象,仅用于查询 SYSMAN 用户对象

FLOWS_FILES

是Oracle Application Express的系统账号,该账户拥有oracle application express上传的文件。

MDSYS/MDSYS

MDSYS是ORACLE的空间数据(spatial)和媒介(interMedia)、音频(audio)、视频(Vidio)及图象的管理员用户名。


ORDSYS/ORDSYS

ORDSYS是ORACLE InterMedia Audio Video Locator 和Image的用户名。它有CONNECT和RESOURCE角色。


EXFSYS/EXFSYS

表达式过滤器用户

dbsnmp/dbsnmp

目录集成平台用户,DBSNMP包括CONNECT,RESOURCEHE SNMPAGENT数据库角色。

创建脚本:?/rdbms/admin/catsnmp.SQL, called from catalog.SQL

可以改变密码--需要放置新密码到snmp_rw.ora文件

如果不需要Intelligent agents,可以删除该用户。

WMSYS/WMSYS

工作空间管理帐户


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.

ctxsys

interMedia Text用户


anonymous

用来访问ORACLE XML DB知识库的账户。

SYSMAN/OEM_TEMP

企业管理器帐户

XDB/CHANGE_ON_INSTALL

xml db帐户

ORDPLUGINS

The Oracle interMedia user. Plug-ins supplied by Oracle and third party format plug-ins are installed in this schema.

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. 

SI_INFORMTN_SCHEMA

静止图像标准浏览帐户(The account that stores the information views for the SQL/MM Still Image Standard)

OLAPSYS

用于创建OLAP元数据的用户。包括OLAP_DBA\RESOURCE\CONNECT角色

 scott/tiger

实验、测试用户,含有例表empdept

创建脚本:?/rdbms/admin/utlsampl.SQL

可以修改密码,用户可以被删除,在产品环境建议删除或锁定

ORACLE_OCM

Oracle 预定义的非管理员用户

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. 
    • 创建脚本:$ORACLE_HOME/demo/schema/product_media/pm_main.sql



MDDATA

The schema used by Oracle Spatial for storing Geocoder and router data.


IX

The account that owns the Information Transport schema included in the Oracle Sample Schemas.


The account that owns the Information Transport schema included in the Oracle Sample Schemas

 sh/sh (sales history)

实验、测试用户,含有例表products、sales、customers等

可以修改密码,用户可以被删除,在产品环境建议删除或锁定


DIP

目录集成平台的帐户(DIRECTORY INTEGERATION PLATFORM)

OE

示例用户。

HR/HR

实验、测试用户,含有例表empLoyeesdepartments

创建脚本:?/demo/schema/mksample.SQL

可以修改密码,用户可以被删除,在产品环境建议删除或锁定





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_USRMDDATA 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.

参考文档
https://www.baidu.com/link?url=wFfHey6aizdoiHbuZ_dBRd-yVIiIl4nfLPG0xuA1kG4Dv3v6IVF_e28_BKKaacEjFk-ITaOFSfNq68sdYQM0Y_&wd=oracle%20%E2%80%8Bspatial_csw_admin_usr&issp=1&f=8&ie=utf-8&tn=baiduhome_pg&inputT=14065&oq=oracle%20anony




来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30496894/viewspace-1806081/,如需转载,请注明出处,否则将追究法律责任。

上一篇: oracle索引讲解
请登录后发表评论 登录
全部评论

注册时间:2015-09-21

  • 博文量
    211
  • 访问量
    281324