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
答案解析:有
微信扫一扫手机做题