Oracle
1Z0-146 · Question #69
You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schem a. The user sessions are able to access only the desired rows. The database administrator (DBA)…
The correct answer is C. The subsequent queries on the ORDERS table within the current session are not controlled by the. See the full explanation below for the reasoning.
Question
You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schem a. The user sessions are able to access only the desired rows. The database administrator (DBA) uses the following command:
SQL> EXECUTE DBMS_RLS.ENABLE_POLICY('OE','ORDERS','OE_ORDERS_ACCESS_POLICY',FALSE); Which statement is true about user sessions that are connected currently?
Options
- AThe security policy remains in effect till the end of the current session.
- BThe subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error.
- CThe subsequent queries on the ORDERS table within the current session are not controlled by the
- DThe subsequent queries on the ORDERS table produce an ORA-28112: failed to execute policy
How the community answered
(22 responses)- A5% (1)
- B14% (3)
- C77% (17)
- D5% (1)
Community Discussion
No community discussion yet for this question.