点击(此处)折叠或打开
- SQL>
- SQL> select * from v$version;
-
- BANNER
- --------------------------------------------------------------------------------
- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
- PL/SQL Release 11.2.0.3.0 - Production
- CORE 11.2.0.3.0 Production
- TNS for Linux: Version 11.2.0.3.0 - Production
- NLSRTL Version 11.2.0.3.0 - Production
-
- SQL>
- SQL>
- SQL> select username,account_status,created from dba_users;
-
- USERNAME ACCOUNT_STATUS CREATED
- ------------------------------ -------------------------------- ---------
- SYS OPEN 18-SEP-11
- SYSTEM OPEN 18-SEP-11
- OUTLN EXPIRED & LOCKED 18-SEP-11
- MGMT_VIEW EXPIRED & LOCKED 18-SEP-11
- FLOWS_FILES EXPIRED & LOCKED 18-SEP-11
- MDSYS EXPIRED & LOCKED 18-SEP-11
- ORDSYS EXPIRED & LOCKED 18-SEP-11
- EXFSYS EXPIRED & LOCKED 18-SEP-11
- DBSNMP EXPIRED & LOCKED 18-SEP-11
- WMSYS EXPIRED & LOCKED 18-SEP-11
- APPQOSSYS EXPIRED & LOCKED 18-SEP-11
- APEX_030200 EXPIRED & LOCKED 18-SEP-11
- OWBSYS_AUDIT EXPIRED & LOCKED 18-SEP-11
- ORDDATA EXPIRED & LOCKED 18-SEP-11
- CTXSYS EXPIRED & LOCKED 18-SEP-11
- ANONYMOUS EXPIRED & LOCKED 18-SEP-11
- SYSMAN EXPIRED & LOCKED 18-SEP-11
- XDB EXPIRED & LOCKED 18-SEP-11
- ORDPLUGINS EXPIRED & LOCKED 18-SEP-11
- OWBSYS EXPIRED & LOCKED 18-SEP-11
- SI_INFORMTN_SCHEMA EXPIRED & LOCKED 18-SEP-11
- OLAPSYS EXPIRED & LOCKED 18-SEP-11
- SCOTT EXPIRED & LOCKED 18-SEP-11
- ORACLE_OCM EXPIRED & LOCKED 18-SEP-11
- XS$NULL EXPIRED & LOCKED 18-SEP-11
- BI EXPIRED & LOCKED 13-OCT-14
- PM EXPIRED & LOCKED 13-OCT-14
- MDDATA EXPIRED & LOCKED 18-SEP-11
- IX EXPIRED & LOCKED 13-OCT-14
- SH EXPIRED & LOCKED 13-OCT-14
- DIP EXPIRED & LOCKED 18-SEP-11
- OE EXPIRED & LOCKED 13-OCT-14
- APEX_PUBLIC_USER EXPIRED & LOCKED 18-SEP-11
- HR EXPIRED & LOCKED 13-OCT-14
- SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED 18-SEP-11
- SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED 18-SEP-11
-
- 36 rows selected.
-
- 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
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
实验、测试用户,含有例表emp与dept
创建脚本:?/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
实验、测试用户,含有例表empLoyees与departments
创建脚本:?/demo/schema/mksample.SQL
可以修改密码,用户可以被删除,在产品环境建议删除或锁定
- 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.
参考文档
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/30162081/viewspace-1595204/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30162081/viewspace-1595204/