You imposed a column-level Virtual Private Database (VPD) policy as follows:
BEGIN
DBMS_RLS.ADD_POLICY (object_schema=> ‘scott’,
object_name => ’employees’,
policy_name => ‘hr_policy’,
function_schema => ‘pol_hr’,
policy_function => ‘hrpol’,
sec_relevant_clos => ‘salary , commission_pct ‘ ) ;
END;
Which statement regarding hr_policy is true?
A.
The policy applies only to the INDEX statement and note to any other statements
B.
The policy applies only to the SELECT statement and not to any other statements.
C.
The policy applies to SELECT, INSERT, UPDATE, DELETE, and INDEX statements.
D.
The policy applies to SELECT, INSERT, UPDATE and DELETE statements; it does not apply to INDEX statements.
Explanation:
DBMS_RLS.ADD_POLICY (
object_schema IN VARCHAR2 NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
function_schema IN VARCHAR2 NULL,
policy_function IN VARCHAR2,
statement_types IN VARCHAR2 NULL,
update_check IN BOOLEAN FALSE,
enable IN BOOLEAN TRUE,
static_policy IN BOOLEAN FALSE);
statement_types is the statement types to which the policy applies. It can be any combination of SELECT, INSERT, UPDATE, and DELETE. The default is to apply to all of these types.
The policy not applies on the INDEX statements.