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