oracle安装默认用户都是做什么用的？oracle必须用的用户是哪几个？

[java_develop]

如题

[adrianlynn]

SYS和SYSTEM用户是默认且必须的。
SYS用户拥有SYSDBA权限，可以访问DBA视图（包含所有用户信息），包含了SYSTEM用户的所有权限；
SYSTEM用户拥有DBA权限，可以创建用户、管理表空间等，只能访问USER视图（只包含当前用户信息）；
大致是这样。

[hxmsammi]

[Quote=引用 1 楼 Adrianlynn 的回复:]
SYS和SYSTEM用户是默认且必须的。
SYS用户拥有SYSDBA权限，可以访问DBA视图（包含所有用户信息），包含了SYSTEM用户的所有权限；
SYSTEM用户拥有DBA权限，可以创建用户、管理表空间等，只能访问USER视图（只包含当前用户信息）；
大致是这样。
[/Quote]

学习下

[owl1230]

基本上就这些
另外有reman，snmp等用户

[hery2002]

scott/tiger 测试账户,一般权限.

[hery2002]

http://blog.cnfol.com/xiaolu/article/1320873.html
oracle 10g 默认安装带来的用户名/密码
User/pwd Desc.
-------------- ----------------------------------------------------------------------
CTXSYS/CTXSYS The Oracle Text account
Oracle Text Reference

DBSNMP/DBSNMP The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enterprise Manager Grid Control Installation and Basic Configuration

LBACSYS/LBACSYS The Oracle Label Security administrator account
Oracle Label Security Administrator's Guide

MDDATA/MDDATA The schema used by Oracle Spatial for storing Geocoder and router data
Oracle Spatial User's Guide and Reference

MDSYS/MDSYS The Oracle Spatial and Oracle interMedia Locator administrator account
Oracle Spatial User's Guide and Reference

DMSYS/DMSYS The Oracle Data Mining account.
Oracle Data Mining Administrator's Guide/Oracle Data Mining Concepts

OLAPSYS/MANAGER The account used to create OLAP metadata structures. It owns the OLAP Catalog (CWMLite).
Oracle OLAP Application Developer's Guide

ORDPLUGINS/ORDPLUGINS The Oracle interMedia user. Plug-ins supplied by Oracle and third party
format plug-ins are installed in this schema.
Oracle interMedia User's Guide

ORDSYS/ORDSYS The Oracle interMedia administrator account
Oracle interMedia User's Guide

OUTLN/OUTLN The account that supports plan stability. Plan stability enables you
to maintain the same execution plans for the same SQL statements.
OUTLN acts as a role to centrally manage metadata associated with stored outlines.
Oracle Database Performance Tuning Guide

SI_INFORMTN_SCHEMA/SI_INFORMTN_SCHEMA
The account that stores the information views for the SQL/MM Still Image Standard
Oracle interMedia User's Guide

SYS/CHANGE_ON_INSTALL The account used to perform database administration tasks
Oracle Database Administrator's Guide

SYSMAN/CHANGE_ON_INSTALL The account used to perform Oracle Enterprise Manager database administration tasks. Note that SYS and SYSTEM can also perform these tasks.
Oracle Enterprise Manager Grid Control Installation and Basic Configuration

SYSTEM/MANAGER Another account used to perform database administration tasks

[oracle_dba_11]

[Quote=引用 1 楼 Adrianlynn 的回复:]
SYS和SYSTEM用户是默认且必须的。
SYS用户拥有SYSDBA权限，可以访问DBA视图（包含所有用户信息），包含了SYSTEM用户的所有权限；
SYSTEM用户拥有DBA权限，可以创建用户、管理表空间等，只能访问USER视图（只包含当前用户信息）；
大致是这样。
[/Quote]