SQL> conn xc/xc@xiaochua as sysdba;
已连接。
SQL> set linesize 3000;
SQL> select * from product_user_profile;PRODUCT USERID ATTRIBUTE
------------------------------ ------------------------------ -----------------------
SQL*PLUS xiao insert
SQL*PLUS 55 INSERT
SQL*PLus XIAO DELETE
SQL*PLUS XIAO DELETE
SQL*Plus xiao delete SQL> conn xiao/xc@xiaochua
已连接。
SQL> select * from xiao ; NO NAME AGE
---------- ------------------------------ ----------
1 xiaoA 20
2 xiaochuang 23
11 xiao 22
12 ceshi 44
4 x1111x 40
5 dada 40
6 dasdadda 60
23 sdasda 33已选择8行。SQL> delete from xiao where name='ceshi';已删除 1 行。
设置的权限无效。请问是什么原因?SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 4月 19 21:46:49 2013Copyright (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
Oracle
已连接。
SQL> set linesize 3000;
SQL> select * from product_user_profile;PRODUCT USERID ATTRIBUTE
------------------------------ ------------------------------ -----------------------
SQL*PLUS xiao insert
SQL*PLUS 55 INSERT
SQL*PLus XIAO DELETE
SQL*PLUS XIAO DELETE
SQL*Plus xiao delete SQL> conn xiao/xc@xiaochua
已连接。
SQL> select * from xiao ; NO NAME AGE
---------- ------------------------------ ----------
1 xiaoA 20
2 xiaochuang 23
11 xiao 22
12 ceshi 44
4 x1111x 40
5 dada 40
6 dasdadda 60
23 sdasda 33已选择8行。SQL> delete from xiao where name='ceshi';已删除 1 行。
设置的权限无效。请问是什么原因?SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 4月 19 21:46:49 2013Copyright (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
Oracle
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货