不管用什么as sysdba,最终都归于以sys用户登录
1 conn其他用户
conn">sys@ora10g>conn ring/ring as sysdba
已连接。
show">sys@ora10g>show user
USER 为 "SYS"
2 其他用户以sysdba登录
sqlplus ring as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 8月 28 23:29:16 2007
Copyright (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
show">sys@ora10g>show user
USER 为 "SYS"
3 哪怕一个不存在的用户,密码乱输一通,也是以SYS用户登录成功
C:>sqlplus dfas?fae as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 8月 28 23:48:22 2007
Copyright (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
show">sys@ora10g>show user
USER 为 "SYS"
不知道是什么原因,先猜测是因为操作系统认证的原因吧.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-966731/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-966731/