You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS
table in the OE schema. 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?
A.
The security policy remains in effect till the end of the current session.
B.
The subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges
error.
C.
The subsequent queries on the ORDERS table within the current session are not controlled by
the security policy.
D.
The subsequent queries on the ORDERS table produce an ORA-28112: failed to execute
policy function error.
C