问题:
A user named Arren is executing this query:
select table_name,operation,undo_sql
from
flashback_transaction_query t,
(select versions_xid as xid
from employees versions between scn minvalue and maxvalue
where employee_id = 123) e
where t.xid = e.xid;
When the query runs,he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table,you know that it is not the problem.
Which of the following SQL statements will correct this problem?()
A . GRANT SELECT ANY TRANSACTION TO ARREN
B . GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN
C . GRANT SELECT_ANY_TRANSACTION TO ARREN
D . GRANT FLASHBACK TO ARREN
E . GRANT SELECT ANY VIEW TO ARREN
A user named Arren is executing this query:
select table_name,operation,undo_sql
from
flashback_transaction_query t,
(select versions_xid as xid
from employees versions between scn minvalue and maxvalue
where employee_id = 123) e
where t.xid = e.xid;
When the query runs,he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table,you know that it is not the problem.
Which of the following SQL statements will correct this problem?()
● 参考解析
本题暂无解析