是这样:我用systemcreate user opmadm identifier by opmadm;grant dba to opmadm;reovke dba from opmadm; 之后,我用sqldeveloper登陆 用户:opmadm:密码:opmadm; 身份:SYSDBA 竟然登陆进去了;而且用命令窗口sqlplus登陆 也可以以SYSDBA登陆。但是普通用户身份登陆不了。 之后我再一次grant dba,普通身份也可以登陆了。
对了,我上传的图片是问题出现后为了方便大家理解,重复操作了一遍,忘记了一步操作,commit;但是问题出现那次操作我是做了commit 的,grant 和 revoke 后都有commit;
对了,我上传的图片是问题出现后为了方便大家理解,重复操作了一遍,忘记了一步操作,commit;但是问题出现那次操作我是做了commit 的,grant 和 revoke 后都有commit;
http://topic.csdn.net/u/20110801/10/e5940624-2661-4394-9d0e-e7ee8b6a918e.html
---他认证的是你的操作系统帐户,你可以随便输入用户名和密码都能进入
sqlplus asdasd/asdadasd as sysdba;
"
这就是原因? 有点不可思议
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options[SYS@myorcl] SQL>exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开C:\Documents and Settings\Administrator>sqlplus adsasdasdasd/adadasdfedfdsfasd123 as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 8月 25 16:17:06 2011Copyright (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 options[SYS@myorcl] SQL>exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开C:\Documents and Settings\Administrator>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 8月 25 16:17:15 2011Copyright (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 options[SYS@myorcl] SQL>