SQL> select object_name,object_type,owner from dba_objects where object_name='FLASHBACK_TRANSACTION_QUERY';
OBJECT_NAME
OBJECT_TYPE OWNER
-------------------------------------------------------------------------------------------------------------------------------- ------------------- ------------------------------
FLASHBACK_TRANSACTION_QUERY
VIEW
SYS
FLASHBACK_TRANSACTION_QUERY
SYNONYM
PUBLIC
SQL> grant select on flashback_transaction_query to scott;
Grant succeeded.
问题 1)赋权成功,但scott仍然无法查询该view. 这是为什么呢?
SQL>conn scott/tiger
Connected.
SQL> select xid,commit_scn,commit_timestamp,operation,undo_sql from flashback_transaction_query q where q.xid in(select versions_xid from a versions between scn
*
ERROR at line 1:
ORA-01031: insufficient privileges
问题 2):
如果sysdb操作: SQL> grant select any transaction to scott;
Grant succeeded.
这个时候scott就可以查看flashback_transaction_query视图了,这又是问什么呢? |