那为甚末我可以在server端用adm以sysdba login (sqlplus adm/adm@orcl as sysdba) ?
服务器端执行grant resource,connect to adm; 客户端还按你原来那么登陆你再看看行不行
是这样的。 d:\>sqlplus "chennan/chennan@cwtest201 as sysdba"SQL*Plus: Release 9.2.0.8.0 - Production on 星期一 7月 21 10:29:20 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.ERROR: ORA-01031: insufficient privileges 请输入用户名: d:\> d:\> d:\> d:\>sqlplus /nologSQL*Plus: Release 9.2.0.8.0 - Production on 星期一 7月 21 10:29:38 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn chennan/chennan@cwtest201 as sysdba ERROR: ORA-01031: insufficient privileges SQL> conn sys/chennan@cwtest201 as sysdba 已连接。 SQL> grant sysdba to chennan 2 ;授权成功。SQL> exit 从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production中断开d:\>sqlplus "chennan/chennan@cwtest201 as sysdba"SQL*Plus: Release 9.2.0.8.0 - Production on 星期一 7月 21 10:38:20 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Productionsys@cwtest201> sys@cwtest201>
客户端还按你原来那么登陆你再看看行不行
是这样的。
d:\>sqlplus "chennan/chennan@cwtest201 as sysdba"SQL*Plus: Release 9.2.0.8.0 - Production on 星期一 7月 21 10:29:20 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.ERROR:
ORA-01031: insufficient privileges
请输入用户名:
d:\>
d:\>
d:\>
d:\>sqlplus /nologSQL*Plus: Release 9.2.0.8.0 - Production on 星期一 7月 21 10:29:38 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn chennan/chennan@cwtest201 as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL> conn sys/chennan@cwtest201 as sysdba
已连接。
SQL> grant sysdba to chennan
2 ;授权成功。SQL> exit
从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开d:\>sqlplus "chennan/chennan@cwtest201 as sysdba"SQL*Plus: Release 9.2.0.8.0 - Production on 星期一 7月 21 10:38:20 2008Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Productionsys@cwtest201>
sys@cwtest201>