oracle9i 默认用户

oracle9i的默认用户：SQL> select username,account_status from dba_users;USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SYS                            OPEN
SYSTEM                         OPEN
DBSNMP                         OPEN
ODS                            OPEN
OUTLN                          EXPIRED & LOCKED
ORDSYS                         EXPIRED & LOCKED
MDSYS                          EXPIRED & LOCKED
QS_ES                          EXPIRED & LOCKED
QS                             EXPIRED & LOCKED
QS_CBADM                       EXPIRED & LOCKED
QS_CB                          EXPIRED & LOCKED
QS_CS                          EXPIRED & LOCKED
RMAN                           EXPIRED & LOCKED
HR                             EXPIRED & LOCKED
OE                             EXPIRED & LOCKED
PM                             EXPIRED & LOCKED
SH                             EXPIRED & LOCKED
QS_ADM                         EXPIRED & LOCKED
OLAPSYS                        EXPIRED & LOCKED
ODM_MTR                        EXPIRED & LOCKEDUSERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
ODM                            EXPIRED & LOCKED
WKPROXY                        EXPIRED & LOCKED
WKSYS                          EXPIRED & LOCKED
ANONYMOUS                      EXPIRED & LOCKED
XDB                            EXPIRED & LOCKED
QS_OS                          EXPIRED & LOCKED
QS_WS                          EXPIRED & LOCKED
CTXSYS                         EXPIRED & LOCKED
ORDPLUGINS                     EXPIRED & LOCKED
WMSYS                          EXPIRED & LOCKED
SCOTT                          OPEN
ODSCOMMON                      OPEN33 rows selected其中除sys,system,scott等外，其它账户在默认情况下是锁住的。
查看账户是否可用，通过上面的SQL语句就可知晓，它们最主要的区别在于：
账户sys带有sysdba与sysoper权限，是超级用户，在Oracle数据库中具有至高无上的权力；
账户system的角色是dba，权限仅次于sys账户；
账户scott是Oracle自带的示例账户，主要用于操作它自已的表等对象，所以它的权限仅能用于
对它自己的表进行操作。另外在9i中我好像没见过默认账户internal。