版本: 9.2.0.1.0
系統: XP Professional
SQL> conn sys/sys@ora92 as sysdba;
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL>
謝謝啊!
但是我用下面的語句時保錯:
SQL> conn /@ora92 as sysdba;
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
如果我不用 as sysdba的方法聯接的話,也會保錯.
SQL> conn sys/sys@ora92
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
SQL>
那如何Grant sysdba權限給sys?
而且為什麼我用sys聯接的話,就一定要用sysdba或者sysoper的身份聯接(如下)
SQL> conn sys/sys@ora92
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper
Warning: You are no longer connected to ORACLE.
SQL>