dba role权限问题 我有个用户abc,我查看role的时候是有dba role的,权限里面dba的权限都是yes,只是没有admin option,但是我在sqlplus里面conn as sysdba时,他总是提示权限不足,这是为什么啊…… 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 connect和resource的role都有的,正常连接正常的,就是不能dba conn abc/password@sid as sysdba SQL> grant dba to scott; Grant succeeded SQL> conn scott/scott@orcl as sysdba;Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Connected as scott@orcl AS SYSDBA SQL> show user;User is "SYS" SQL> SQL> grant dba to scott; Grant succeeded SQL> conn scott/scott@orcl as sysdba;Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Connected as scott@orcl AS SYSDBA SQL> show user;User is "SYS" SQL> conn scott/scott@orcl;Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 Connected as scott@orcl SQL> show user;User is "scott" SQL> grant dba to user; 菜鸟之问题_请问下oracle10G各个服务启动的先后顺序? 特别急特别,过来看看 数据库 我服务器上的oracle9i莫名其妙得多出了两个存储过程,是不是被入侵了 求关于某个字段内容的长度 为什么存储过程和包经常会无缘无故出现红叉? 两条update语句如何合并为一条语句? 新手提问:关于字段更新 求一UPDATE语句,从一表向另一表中更新内容 郁闷啊,学了1个多月oracle,感觉和没学一样,哪位介绍一下好书啊 这个怎么做啊!orcal 基础题 换行符问题
Grant succeeded
SQL> conn scott/scott@orcl as sysdba;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as scott@orcl AS SYSDBA
SQL> show user;
User is "SYS"
SQL>
Grant succeeded
SQL> conn scott/scott@orcl as sysdba;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as scott@orcl AS SYSDBA
SQL> show user;
User is "SYS"
SQL> conn scott/scott@orcl;
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as scott@orcl
SQL> show user;
User is "scott"
SQL>