alter user scott identified by 사용할암호 account unlock;
'Oracle > ORACLE 일반' 카테고리의 다른 글
Oracle Created (Default) Database Users (0) | 2008.09.02 |
---|
Oracle Created (Default) Database Users (0) | 2008.09.02 |
---|
[펌] 윈도에서 숨겨진 하드웨어 드라이버 지우기 (0) | 2005.04.06 |
---|---|
윈도우 유용한 사이트 (0) | 2004.08.18 |
자바 JRE/JDK 환경변수 설정 (0) | 2008.08.28 |
---|
XML 관련 site (0) | 2008.01.30 |
---|---|
J2EE, 톰캣 , 스트럿츠 (0) | 2008.01.30 |
각종 script 에디터 link (0) | 2008.01.30 |
이클립스 관련 site (0) | 2008.01.30 |
Oracle 관련 site (0) | 2008.01.30 |
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.
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 | ||
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 | ||
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 | ||
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) |
oracle 설치 후(10g) Lock 걸린 유저 풀어주기 (0) | 2008.11.12 |
---|
TOMCAT/Weblogic 설정관련 링크 (0) | 2008.10.15 |
---|
==================================================================================
XML 싸이트
-----------------------------------------------------------------------------------
안항준의 XML : http://my.netian.com/~aphise/
XML 스터디 : http://www.xmlstudy.co.kr/
김종민의 XML : http://xml.80port.net/
XML Developer Group : http://xml.geonji.co.kr/
Rapsodie's XML Resource : http://user.chollian.net/~rapsodie/main.html
용어사전과 XML : http://trio.co.kr/
HowXML : http://www.howxml.com/
군산대학교 XML 연구실 : http://xmlab.kunsan.ac.kr/
XML 강좌 링크 : http://www.howon.ac.kr/~ktlim/lecture/xml/xml-index.htm
코리아 인터넷 XML 강좌 : http://korea.internet.com/channel/index.asp?cid=193
XML 홈페이지 만들기 강의 자료 : http://muse.inchon.ac.kr/jschae/internet_xml.html
XML 강의 자료 : http://kuic.kyonggi.ac.kr/~ejlee/xml/#course-note
XML 강의 : http://hyejeon.ac.kr/%7Ekrkuki/xmlq_1.html
자바지기 XML 강좌 : http://wiki.javajigi.net/display/XML/Home
최신 공개 한글 글꼴 정리 (0) | 2008.09.15 |
---|---|
J2EE, 톰캣 , 스트럿츠 (0) | 2008.01.30 |
각종 script 에디터 link (0) | 2008.01.30 |
이클립스 관련 site (0) | 2008.01.30 |
Oracle 관련 site (0) | 2008.01.30 |
--------------------------------------------------------------------------------------
(J2EE 개발 및 JSP 개발시 유용한 플러그인)
1. 다운로드 주소
롬보즈 다운로드 링크 : http://forge.objectweb.org/projects/lomboz
2. 직접 다운
미국 : http://download.us.forge.objectweb.org/lomboz/lomboz.213.zip
프랑스 : http://download.fr2.forge.objectweb.org/lomboz/lomboz.213.zip
중국 : http://download.zh.forge.objectweb.org/lomboz/lomboz.213.zip
c:eclipse라는 폴더에 압축을 해제.
---------------------------------------------------------------------------------------
(톰캣 개발시 유용한 플러그인)
1. 다운로드 주소
톰캣 플러그인 : http://www.sysdeo.com/eclipse/tomcatPlugin.html
2. 직접 다운
http://www.sysdeo.com/sysdeo/content/download/350/4721/file/tomcatPluginV31beta.zip
tomcatPluginV3.zip 다운 받아서 압축 해제해서
C:eclipseplugins 에 복사
---------------------------------------------
(스트럿츠 개발시 유용한 플러그인)
EasyStruts : eclipse 에서 스트럿츠 개발시 사용하는 플러그인.
1. 다운로드 : 주소
http://sourceforge.net/projects/easystruts
2. 직접 다운로드
http://prdownloads.sourceforge.net/easystruts/org.easystruts.eclipse_0.6.4.zip?download
------------------------------------------------
(스트럿츠)
1. 스트럿츠 다운
http://archive.apache.org/dist/struts/
2. 스트럿츠 직접 다운로드
http://ftp.apache-kr.org/struts/binaries/struts-1.2.7.zip
http://mirror.apache.or.kr/jakarta/struts/binaries/jakarta-struts-1.1.zip
(ANT 다운 로드)
http://www.apache.org/dist/ant/
------------------------------------------------
(스트럿츠 참고 싸이트)
자바 프레임워크(네이버 스트럿츠 카페) : http://cafe.naver.com/deve.cafe
최신 공개 한글 글꼴 정리 (0) | 2008.09.15 |
---|---|
XML 관련 site (0) | 2008.01.30 |
각종 script 에디터 link (0) | 2008.01.30 |
이클립스 관련 site (0) | 2008.01.30 |
Oracle 관련 site (0) | 2008.01.30 |
자바스크립트 에디터 : http://sourceforge.net/projects/jseditor
http://heanet.dl.sourceforge.net/sourceforge/jseditor/net.sf.wdte.js_0.0.9b.zip
CSS 에디터 : http://www.vasanthdharmaraj.com/Software.aspx?=csseditor
JSEclipse : http://www.interaktonline.com/downloads/eclipse/100/JSEclipse_1.2.1.zip
XML 관련 site (0) | 2008.01.30 |
---|---|
J2EE, 톰캣 , 스트럿츠 (0) | 2008.01.30 |
이클립스 관련 site (0) | 2008.01.30 |
Oracle 관련 site (0) | 2008.01.30 |
My sql site (0) | 2008.01.30 |
==================================================================================
이클립스 eclipse 3.0.2 다운로드 정리
한국의 미러 싸이트 : http://eclipse.areum.biz/downloads/
이클립스 3.0.2 : http://eclipse.areum.biz/downloads/drops/R-3.0.2-200503110845/eclipse-SDK-3.0.2-win32.zip
톰캣 플러그인 : http://www.sysdeo.com/sysdeo/content/download/350/4721/file/tomcatPluginV31beta.zip
롬보즈 : http://download.fr2.forge.objectweb.org/lomboz/org.objectweb.lomboz_3.0.1.N20050106.zip
롬보즈 실행을 위한 도구 : http://download.fr2.forge.objectweb.org/lomboz/emf-sdo-runtime-2.0.0.zip (롬보즈를 쓰려면 같이 다운받아서 압축 풀어 쓴다.)
롬보즈 사용 예제 모음(영어) :http://www.objectlearn.com/support/docs/index.jsp
이클립스 플러그인 : http://www.eclipse-plugins.info/eclipse/index.jsp
==================================================================================
자카르타 Ant 한글 싸이트 : http://ant.apache-korea.org/
자카르타 Ant 다운로드 : http://ant.apache.org/bindownload.cgi
ant 직접 다운 로드 : http://ftp.apache-kr.org/ant/binaries/apache-ant-1.6.5-bin.zip
==================================================================================
이클립스 eclipse 3.1.1 다운로드 정리
한국의 미러 싸이트 : http://eclipse.areum.biz/downloads/
이클립스 3.1.1 : http://eclipse.areum.biz/downloads/drops/R-3.1.1-200509290840/download.php?dropFile=eclipse-SDK-3.1.1-win32.zip
톰캣 플러그인 : http://www.sysdeo.com/eclipse/tomcatPlugin.html
직접 다운 : http://www.sysdeo.com/sysdeo/content/download/350/4721/file/tomcatPluginV31beta.zip
롬보즈 플러그인 : http://forge.objectweb.org/projects/lomboz
http://download.fr2.forge.objectweb.org/lomboz/
lomboz-emf-gef-jem-3.1RC2 : http://download.fr2.forge.objectweb.org/lomboz/lomboz-emf-gef-jem-3.1RC2.zip
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
기타 플러그인 정리
롬보즈3.1RC2 : http://download.fr2.forge.objectweb.org/lomboz/lomboz-3.1RC2.zip
lomboz/lomboz-eclipse-emf-gef-jem-3.1RC2 : http://download.fr2.forge.objectweb.org/lomboz/lomboz-eclipse-emf-gef-jem-3.1RC2.zip
GEF : ftp://ftp.jaist.ac.jp/pub/eclipse/tools/gef/downloads/drops/R-3.1.1-200509301327/GEF-ALL-3.1.1.zip
VE : ftp://ftp.jaist.ac.jp/pub/eclipse/tools/ve/downloads/drops/R-1.1.0.1-200509071822/VE-SDK-1.1.0.1.zip
UML2 : ftp://ftp.jaist.ac.jp/pub/eclipse/tools/uml2/downloads/drops/1.1.1/R200509282050/uml2-SDK-1.1.1.zip
JEM : ftp://ftp.jaist.ac.jp/pub/eclipse/tools/ve/downloads/drops/R-1.1-200507221721/JEM-SDK-1.1.zip
eclipseUML : http://www.eclipsedownload.com/eclipseUML_freeEdition_2.1.0/eclipseUML_E310_freeEdition_2.1.0.20050927.jar
----------------------------------------------------------------------------------------
데이타베이스 관련 이클립스 플러그인
----------------------------------------------------------------------------------------
DBEdit : http://sourceforge.net/projects/dbedit/
DBEdit Down : http://jaist.dl.sourceforge.net/sourceforge/dbedit/dbedit_1.0.3_1.bin.dist_3.X.zip
SQLExplorer : http://sourceforge.net/projects/eclipsesql/
SQLExplorer down : http://keihanna.dl.sourceforge.net/sourceforge/eclipsesql/net.sourceforge.sqlexplorer_2.2.4.zip
quantumDB : http://quantum.sourceforge.net/
quantumDB 다운 : http://keihanna.dl.sourceforge.net/sourceforge/quantum/com.quantum.feature_3.0.1.bin.dist.zip
J2EE, 톰캣 , 스트럿츠 (0) | 2008.01.30 |
---|---|
각종 script 에디터 link (0) | 2008.01.30 |
Oracle 관련 site (0) | 2008.01.30 |
My sql site (0) | 2008.01.30 |
JAVA & JSP site (0) | 2008.01.30 |