赋 系统视图权限 给用户的问题

Question

SQL> conn / as sysdba
已连接。
SQL> grant all on flashback_transaction_query to xiong;授权成功。SQL> conn xiong/cexo1234
已连接。
SQL> select operation,undo_sql from flashback_transaction_query where table_name
='TEMP' and table_owner='XIONG';
select operation,undo_sql from flashback_transaction_query where table_name='TEM
P' and table_owner='XIONG'
                               *
第 1 行出现错误:
ORA-01031: 权限不足提示授权成功,为何还是权限不足?

Answer 1

select .... from sys.tablename

Answer 2

楼上的,我没看懂,
我是想把"闪回事务查询视图"的查询权限赋给"xiong"这个用户,

Answer 3

SQL> grant all on flashback_transaction_query to qmys;授权成功。SQL> conn qmys/qmys@29
已连接。
SQL>
SQL>
SQL> desc flashback_transaction_query
 名称                                      是否为空? 类型
 ----------------------------------------- -------- ---------------------------- XID                                                RAW(8)
 START_SCN                                          NUMBER
 START_TIMESTAMP                                    DATE
 COMMIT_SCN                                         NUMBER
 COMMIT_TIMESTAMP                                   DATE
 LOGON_USER                                         VARCHAR2(30)
 UNDO_CHANGE#                                       NUMBER
 OPERATION                                          VARCHAR2(32)
 TABLE_NAME                                         VARCHAR2(256)
 TABLE_OWNER                                        VARCHAR2(32)
 ROW_ID                                             VARCHAR2(19)
 UNDO_SQL                                           VARCHAR2(4000)SQL> select operation,undo_sql from flashback_transaction_query where table_owne
r='QMYS' and rownum=1;OPERATION
--------------------------------
UNDO_SQL
--------------------------------------------------------------------------------UPDATE
update "QMYS"."YSGL_EXCELBASIC" set "FORMULA_COM" = 'YS(3459,利润表,O,16,1894,0)', "FORMULA_VER" = NULL where ROWID = 'AAANNtAAFAABwohAAG';
SQL>

Answer 4

楼主操作的这个表不是xiong用户下的？

Answer 5

SQL> conn xiong/cexo1234
已连接。
SQL> select table_name from user_tables where table_name ='TEMP';TABLE_NAME
------------------------------
TEMP

Answer 6

我跟你的操作一样的,用另一个用户再试了一下,还是不行啊.SQL> conn / as sysdba
已连接。
SQL> grant all on flashback_transaction_query to scott;授权成功。SQL> conn scott/tiger
已连接。
SQL> desc flashback_transaction_query;
 名称                                      是否为空? 类型
 ----------------------------------------- -------- --------------------------- XID                                                RAW(8)
 START_SCN                                          NUMBER
 START_TIMESTAMP                                    DATE
 COMMIT_SCN                                         NUMBER
 COMMIT_TIMESTAMP                                   DATE
 LOGON_USER                                         VARCHAR2(30)
 UNDO_CHANGE#                                       NUMBER
 OPERATION                                          VARCHAR2(32)
 TABLE_NAME                                         VARCHAR2(256)
 TABLE_OWNER                                        VARCHAR2(32)
 ROW_ID                                             VARCHAR2(19)
 UNDO_SQL                                           VARCHAR2(4000)
  1* select operation,undo_sql from flashback_transaction_query
SQL> /
select operation,undo_sql from flashback_transaction_query
                               *
第 1 行出现错误:
ORA-01031: 权限不足用scott可以desc flashback_transaction_query里的内容了,却没有权限查询.这是怎么回事呀?