- 浏览: 134051 次
- 性别:
- 来自: 北京
文章分类
最新评论
-
djb_daydayup:
Map<String, String> map={ ...
JDK1.5/1.6/1.7之新特性总结 -
txin0814:
借鉴。。。 我还得在此上加上英语学习
我的Java学习计划 -
hongmeikaile:
精辟
程序员35岁不是槛 -
king130520:
很好~~借鉴~
我的Java学习计划 -
halk:
工具类的实现目标是:具有很强的通用性;能有较多的重载方法;尽量 ...
编写工具类的总结
Oracle Created (Default) Database Users
by Jeff Hunter, Sr. Database Administrator
During database creation, Oracle creates several default database users or schemas. This article attempts to provide some insight and explain each of these default database users/schemas.
Oracle User Account Details
<!-- ***************************************************** --><!-- *************** DEFAULT USERS ********************* --><!-- ***************************************************** -->
Default Users | ||
Username | Default Password | Account Description |
SYS | change_on_install | All of the base tables and views for the database's data dictionary are stored in the schema SYS. These base tables and views are critical for the operation of Oracle. To maintain the integrity of the data dictionary, tables in the SYS schema are manipulated only by Oracle; they should never be modified by any user or database administrator, and no one should create any tables in the schema of the user SYS.
The DBA should change the password for SYS immediately after database creation!!! |
SYSTEM | manager | The SYSTEM username creates additional tables and views that display administrative information, and internal tables and views used by Oracle tools. Never create in the SYSTEM schema tables of interest to individual users.
SYSTEM is a little bit "weaker" user than SYS, for example, it has no access to so called X$ tables (the very internal structure tables of Oracle). Although in real life you may be in a situation when some product or whatever you want to create objects in above mentioned user's schemas. Be flexible, don't sacriface a product only because it will create some objects in SYS or SYSTEM schema The DBA should change the password for SYSTEM immediately after database creation!!! |
DBSNMP | dbsnmp | Supports Oracle SNMP (Simple Network Management Protocol).
The Oracle Intelligent Agent requires a database logon for each SID that it manages. By default this account is called "DBSNMP" and the password is "DBSNMP". The account name and/or password SHOULD be changed from the default but you will need to make a few additional modifications. In the examples below, you will need to replace any information with brackets < > with the information from your system.
|
OUTLN | outln | Oracle8i adds the OUTLN user schema to support Plan Stability. The OUTLN user acts as a place to centrally manage metadata associated with stored outlines.
This user has DBA role. It is used for plan stability ie. to keep the same execution plans for the same queries even if your system configuration or statistics changes. Execution plans will be the same in different Oracle releases with different optimizers. The DBA should either lock the user account or change the password for the OUTLN user immediately after database creation!!! |
MDSYS | mdsys | Supports Oracle Spatial. Oracle Spatial is an integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly and efficiently in an Oracle8i database.
[..] The spatial attribute of a spatial feature is the geometric representation of its shape in some coordinate space. This is referred to as its geometry. The DBA should either lock the user account or change the password for the MDSYS user immediately after database creation!!! |
ORDSYS | ordsys | Supports Oracle8i Time Series. Oracle8i Time Series (in previous releases called the Oracle8 Time Series Cartridge) is an extension to Oracle8i that provides storage and retrieval of timestamped data through object types. Oracle8i Time Series is a building block for applications rather than being an end-user application in itself. It consists of data types along with related functions for managing and processing time series data.
The DBA should either lock the user account or change the password for the ORDSYS user immediately after database creation!!! |
ORDPLUGINS | ordplugins | Supports Oracle interMedia. Oracle interMedia is a single product that enables Oracle8i to store, manage, and retrieve text, documents, geographic location information, images, audio, and video in an integrated fashion with other enterprise information. Oracle interMedia extends Oracle8i reliability, availability, and data management to text and multimedia content in Internet, electronic commerce, and media-rich applications as well as online Internet-based geocoding services for locator applications.
The DBA should either lock the user account or change the password for the ORDPLUGINS user immediately after database creation!!! |
CTXSYS | ctxsys | Supports Oracle ConText Cartridge. Oracle8 ConText Cartridge provides powerful search, retrieval, and viewing capabilities for text stored in an Oracle8 database. In addition, ConText provides advanced linguistic processing of English-language text.
The DBA should either lock the user account or change the password for the CTXSYS user immediately after database creation!!! |
DSSYS | dssys | Dynamic Services Secured Web Service. Dynamic Services Engine (DS Engine) allows creation, aggregation and deployment of services from a variety of content sources. At the moment, Dynamic Services supports content access from databases (SQL/PLSQL) as well as Internet applications (HTTP/HTTPS). DS Engine can interpret XML and HTML content along with the result sets returned from database access. DS Engine is integrated with Oracle Portal via a Web Provider mechanism. This integration allows all the services registered with DS Engine to be accessible as portlets.
The DBA should either lock the user account or change the password for the DSSYS user immediately after database creation!!! |
PERFSTAT | perfstat | Oracle Statistics Package (STATSPACK) user that supersedes UTLBSTAT/UTLESTAT. The PERFSTAT user will hold all of the tables and packages for the performance diagnostic tool STATSPACK.
Created By: $ORACLE_HOME/rdbms/admin/spcusr.sql |
WKPROXY | change_on_install | Used to support Oracle's Ultrasearch option. This feature (and user) was introduced in Oracle9i. The user account IS NOT locked by default is only assigned the "CREATE SESSION" privilege. None the less, this account is not locked by default and Oracle highly recommends that this default password be changed.
Created By: $ORACLE_HOME/ultrasearch/admin/wk0csys.sql |
WKSYS | change_on_install | Used to support Oracle's Ultrasearch option. This feature (and user) was introduced in Oracle9i. The user account IS NOT locked by default and as you can see below, is granted the highly privileged role of DBA. Given that this user is granted the DBA role and is not locked by default, Oracle highly recommends that this default password be changed.
This support account is assigned the following privileges in Oracle9i:
The default tablespace for this user will be "DRSYS" while its temporary tablespace will be "TEMP". Created By: $ORACLE_HOME/ultrasearch/admin/wk0install.sql |
WMSYS | wmsys | Used to store all the metadata information for Oracle Workspace Manager. This user was introduced in Oracle9i and (like most Oracle9i supporting accounts) is locked by default. The user account is locked because we want the password to be public but restrict access to the account to the SYS schema. So, to unlock the account, DBA privileges are required.
Created By: $ORACLE_HOME/rdbms/admin/owmctab.plb |
XDB | change_on_install | Used to support SQL XML management: XML DB. This user is granted two roles: "RESOURCE" and "JAVAUSERPRIV". Oracle recommends changing the password for this user after creation. This user is configured with a default tablespace of "XDB" and a temporary tablespace of "TEMP".
Created By: $ORACLE_HOME/rdbms/admin/catqm.sql |
ANONYMOUS | ...IDENTIFIED BY VALUES 'anonymous' | Used to support SQL XML management: XML DB. Allows HTTP access to Oracle XML DB. This user should only be used for HTTP logins. The account is locked near the end of the catqm.sql script.
Created By: $ORACLE_HOME/rdbms/admin/catqm.sql |
ODM | odm | Used to support Oracle Data Mining. In Oracle9i, this user is granted the roles: "SELECT_CATALOG_ROLE", "HS_ADMIN_ROLE", "AQ_USER_ROLE". Oracle recommends changing the default password as the account IS NOT locked after creation. The default tablespace for this user is "ODM" with temporary tablespace "TEMP". The "ODM" tablespace is populated with segments from users ODM and ODM_MTR.
Created By: $ORACLE_HOME/dm/admin/dmcrt.sql |
ODM_MTR | mtrpw | Used to support Oracle Data Mining. In Oracle9i, this user is granted "SELECT_CATALOG_ROLE" and "HS_ADMIN_ROLE". Oracle recommends changing the default password as the account IS NOT locked after creation. The default tablespace for this user is "ODM" with temporary tablespace "TEMP". The "ODM" tablespace is populated with segments from users ODM and ODM_MTR.
Created By: $ORACLE_HOME/dm/admin/dmcrt.sql |
OLAPSYS | mtrpw | This user is create if OLAP option is installed and is used to create OLAP metadata structures. In Oracle9i, this user is granted "SELECT_CATALOG_ROLE" and "HS_ADMIN_ROLE". Oracle recommends changing the default password. The default tablespace for this user is "ODM" with temporary tablespace "TEMP". The "ODM" tablespace is populated with segments from users ODM and ODM_MTR.
Created By: $ORACLE_HOME/dm/admin/dmcrt.sql |
TRACESVR | trace | Oracle Trace server. Supports Oracle Trace for OEM in Oracle7. Oracle Trace is used to collect a wide variety of data, such as performance statistics, diagnostic data, system resource usage, and business transaction details.
This user was last used in Oracle7 and can be dropped from databases using Oracle8 and higher. |
REPADMIN | Managed by DBA when user is created. | Replication user. This user is manually created by the DBA using CREATE USER... This user is also created in the scripts: $ORACLE_HOME/ldap/admin/oidrsrms.sql and $ORACLE_HOME/ldap/admin/oidrsms.sql. Oracle recommends changing the default password if automatically created. |
<!-- ***************************************************** --><!-- *************** JSERV Accounts ******************** --><!-- ***************************************************** -->
JSERV Accounts | ||
The three JSERV accounts (AURORA$JIS$UTILITY$, AURORA$ORB$UNAUTHENTICATED and OSE$HTTP$ADMIN) are used internally by Enterprise Java Beans and CORBA Tools and created with randomly-generated passwords 'INVALID_ENCRYPTED_PASSWORD'.
These 3 scripts are launched by init_jis.sql script to install the Oracle Servlet Engine (OSE). Changing their passwords would prevent the ORB from working. This is supposed to change in a future version so that you can change their password. |
||
Username | Default Password | Account Description |
AURORA$ORB$UNAUTHENTICATED | <Random> | Description: Create the public user for the Aurora/ORB. This is the identity any non-validated ORB client will run as. This is the user for users who don't authenticate in the Aurora/ORB
Created By: jisorb.sql |
AURORA$JIS$UTILITY$ | <Random> | Description: Create the public user for the Aurora/ORB. This is the identity any non-validated ORB client will run as. This is the user for users who don't authenticate in the Aurora/ORB
Created By: jisbgn.sql |
OSE$HTTP$ADMIN | <Random> | Description: Create the public user for the Aurora/ORB. This is the identity any non-validated ORB client will run as. This is the user for users who don't authenticate in the Aurora/ORB
Created By: jishausr.sql |
<!-- ***************************************************** --><!-- *************** Sample Schemas ******************** --><!-- ***************************************************** -->
Sample Schemas | ||
Username | Default Password | Account Description |
SCOTT | tiger | Well known and often referenced sample schema. Everyone should know about the magical emp and dept tables. VERY MANY examples in Oracle docs and not only are based on this schema so You should know it!
The user should be dropped in all production databases. |
ADAMS | ||
JONES | ||
CLARK | ||
BLAKE |
<!-- ***************************************************** --><!-- *********** Oracle9i Sample Schemas *************** --><!-- ***************************************************** -->
Oracle9i Sample Schemas | ||
The Oracle9i Sample Schemas provides installed schemas meant to be used for demonstration purposes only. | ||
Username | Default Password | Account Details |
HR | hr | Human Resources schema. The Human Resources division tracks information on the company's employees and facilities. |
OE | oe | Order Entry schema requires "Oracle Spatial" option. The Order Entry division tracks product inventories and sales of the company's products through various channels. |
PM | pm | Product Media schema requires "Oracle JVM" and "Oracle Intermedia" options. The Product Media division maintains descriptions and detailed information on each product sold by the company. |
SH | sh | Sales History schema requires "Oracle OLAP Services" set up. The Sales History division tracks business statistics to facilitate business decisions. |
QS | qs | Queued Shipping schema The Shipping division manages the shipping of products to customer. The sample company has decided to test the use of messaging to manage its proposed B2B applications. |
QS_ES | qs_es | (Eastern Shipping) |
QS_WS | qs_ws | (Western Shipping) |
QS_OS | qs_os | (Overseas Shipping) |
QS_CB | qs_cb | (Customer Billing) |
QS_CS | qs_cs | (Customer Service) |
QS_ADM | qs_adm | (Administration) |
QS_CBADM | qs_cbadm | (Customer Billing Administration) |
转载自:http://www.idevelopment.info/data/Oracle/DBA_tips/Database_Administration/DBA_26.shtml
发表评论
-
oracle MODEL子句
2012-03-13 11:31 1008转载自:http://blog.csdn.net/wh6 ... -
awrrpt
2012-03-08 15:21 978export ORACLE_SID=payment sqlp ... -
脏读-不可重复读-幻影读
2012-03-07 17:55 2226脏读,不可重复读,幻 ... -
Oracle自治事务介绍
2011-11-07 10:41 1022这是一个非常实用的功能,特别用在记录错误日志同时要回滚主事 ... -
oracle批量插入随机数的方法
2011-10-26 14:16 2229创建表dimension_tab DROP TABLE ... -
ORACLE10G清除死锁进程
2011-09-15 10:10 858select Distinct 'alter system k ... -
杀掉JOB
2011-04-25 16:04 1426今天,一同事的job不能直接remove掉。 考虑到是 ... -
Oracle同义词
2010-07-23 12:24 1561Oracle数据库 中 提供了 ... -
oracle连接一直等待也不报错的问题
2010-04-21 14:51 1720今天测试服务器上的程序访问数据库出现了异常,取不到 ... -
oracle行列转换总结(转载)
2010-03-31 12:26 985oracle行列转换总结 最近论坛很多人提的问题都与行列转换 ... -
ORA-12500:TNS:监听程序无法启动专用服务器进程
2009-08-12 11:02 11239最近老遇到:ORA-12500:TNS:监听程序无法启动专用服 ... -
初学者oracle里常用命令详细讲解
2009-08-03 10:47 948第一章:日志管理 1.forcing log switch ... -
oracle重启
2009-08-03 10:44 5661有时候数据死了,或者没有监听,不必重启机子,重启一下数据库服务 ... -
在shell中调用执行存储过程
2009-04-27 13:50 5247基本的shell文件结构如下: sqlplus user/p ... -
logminer的使用和安装
2009-01-16 13:35 1225LogMiner安装和使用的一些心得 ... -
查看最近的日志记录
2008-05-08 15:09 778日志表查看最近的纪录 我想选时间最近的5条记录: select ...
相关推荐
Oracle Database 21c 是最新的版本; 21.3 - 企业版(也包括标准版 2) 适用于Linux x86-64位系统。oracle-database-ee-21c-1.0-1.ol8文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: Oracle ...
Oracle Database 21c 是最新的版本; 21.3 - 企业版(也包括标准版 2) 适用于Linux x86-64位系统。oracle-database-ee-21c-1.0-1.ol8文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: Oracle ...
Welcome to “Beginning SQL for Oracle Database 18C”! Thanks for picking up this book. It’s safe to say you’re interested in learning about Oracle database, as that’s what this book is about. Why ...
Oracle Database 19c 是最新的长期版本,支持期限最长; 19.3 - 企业版(也包括标准版 2) 适用于Linux x86-64系统。oracle-database-ee-19c文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: ...
Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Database's built-in feature set for working with location-based data. A great deal of the information used in business ...
Expert Oracle Database 11g Administration Expert Oracle Database 11g Administration
Oracle Database 19c 是最新的长期版本,支持期限最长; 19.3 - 企业版(也包括标准版 2) 适用于Linux x86-64系统。oracle-database-ee-19c文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: ...
Oracle Database 19c 是最新的长期版本,支持期限最长; 19.3 - 企业版(也包括标准版 2) 适用于Linux x86-64系统。oracle-database-ee-19c文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: ...
《Expert Oracle Database Architecture Oracle Database Programming 9i, 10g, and 11g Techniques and Solutions, Second Edition》的源代码,跟着书做实验用。
Oracle Essentials Oracle Database 11g 4th
Oracle Database 21c 是最新的版本; 21.3 - 企业版(也包括标准版 2) 适用于Linux x86-64位系统。oracle-database-ee-21c-1.0-1.ol8文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: Oracle ...
Oracle数据库如何创建DATABASE LINK
2015 Oracle 技术嘉年华(OTN)分会场1张乐奕 - Oracle 12.2 Sharded Database Management
第1章 Oracle Database 10g体系结构 第2章 安装Oracle Database 10g和创建数据库 第3章 升级到Oracle Database 10g 第4章 规划Oracle应用程序——方法、风险和标准 第Ⅱ部分 SQL和SQL*Plus 第5章 SQL中的基本语法 第...
Oracle Database 10g for Windows安装
ORACLE flashback database测试,主要进行ORACLE flashbackup 闪回整个数据库的实现。
Beginning Oracle Database 12c Administration, 2nd Edition