sys 就和linux/unix 裡面的root使用者 擁有超級許可權sysdba 不是個使用者吧 可以是個有特殊許可權的連線模式 至於區別嘛 看下面的例子[clark@rhel3 bbed]$ sqlplus system/oracleSQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 28 16:20:01 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediateORA-01031: insufficient privilegesSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[clark@rhel3 bbed]$ sqlplus system/oracle as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 28 16:20:19 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL>
sys 就和linux/unix 裡面的root使用者 擁有超級許可權sysdba 不是個使用者吧 可以是個有特殊許可權的連線模式 至於區別嘛 看下面的例子[clark@rhel3 bbed]$ sqlplus system/oracleSQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 28 16:20:01 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediateORA-01031: insufficient privilegesSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[clark@rhel3 bbed]$ sqlplus system/oracle as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 28 16:20:19 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL>