oracle安装时会在windows中创建ORA_DBA用户组, 允许用户以DBA身份登陆,而无需输入密码; 且登陆后,用show user查看当前登陆用户,信息如下:C:\Documents and Settings\seasail>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 4月 26 22:40:15 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining optionsSQL> show user USER 为 "SYS" SQL>
as sysdba是真正的老大,老大一定是在oracle以外的,即不是oracle管理的用户。一般情况下不要这样登录。当初oracle讲师就是这样给我解释的,呵呵。
允许用户以DBA身份登陆,而无需输入密码;
且登陆后,用show user查看当前登陆用户,信息如下:C:\Documents and Settings\seasail>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 4月 26 22:40:15 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsSQL> show user
USER 为 "SYS"
SQL>