Which statement is true about user sessions that are connected currently?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

DBMS_RLS.ENABLE_POLICY(‘OE’,’ORDERS’,’OE_ORDERS_ACCESS_POLICY’,FALSE); — FALSE mean disable the security policy even though the subprogram name is ENABLE_POLICY