376.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;
Answer: A
答案解析：
此题为用户没有足够的权限来查询flashback_transaction_query这张表。
实验验证：
sys@TEST1107> conn scott/tiger
Connected.
scott@TEST1107> select xid from flashback_transaction_query where rownum<5;
select xid from flashback_transaction_query where rownum<5
*
ERROR at line 1:
ORA-01031: insufficient privileges
scott@TEST1107> conn /as sysdba
Connected.
sys@TEST1107> grant select any transaction to scott;
Grant succeeded.
sys@TEST1107> conn scott/tiger
Connected.
scott@TEST1107> select xid from flashback_transaction_query where rownum<5;
XID
----------------
01000900DA0A0000
01000900DA0A0000
01000900DA0A0000
01000900DA0A0000
[oracle@rtest ~]$ oerr ora 01031
01031, 00000, "insufficient privileges"
// *Cause: An attempt was made to change the current username or password
// without the appropriate privilege. This error also occurs if
// attempting to install a database without the necessary operating
// system privileges.
// When Trusted Oracle is configure in DBMS MAC, this error may occur
// if the user was granted the necessary privilege at a higher label
// than the current login.
// *Action: Ask the database administrator to perform the operation or grant
// the required privileges.
// For Trusted Oracle users getting this error although granted the
// the appropriate privilege at a higher label, ask the database
// administrator to regrant the privilege at the appropriate label.
[oracle@rtest ~]$