Which three statements regarding the column-level Virtual Database Policy (VPD) policy are true?

Which three statements regarding the column-level Virtual Database Policy (VPD) policy are true? (Choose three.)

Which three statements regarding the column-level Virtual Database Policy (VPD) policy are true? (Choose three.)

A.
The column-level VPD policy can be applied only to tables.

B.
The security policy is applied whenever the column is referenced in a query.

C.
The column-level VPD policy can be applied to tables and views, but not to synonyms.

D.
The security policy cannot be applied to data manipulation language (DML) statements.

E.
The security policy is applied and statements are rewritten when they access security-relevant

Explanation:
A – False. Virtual private database (VPD) enables you to enforce security, to a fine level of granularity, directly on tables, views, or synonyms. B – True. When a user directly or indirectly accesses a table, view, or synonym protected with aVPD policy, the server dynamically modifies the SQL statement of the user. Themodification creates a WHERE condition (known as a predicate) returned by a function implementing the security policy. The statement is modified dynamically, transparently to the user, using any condition that can be expressed in or returned by a function. VPD policies can be applied to SELECT, INSERT, UPDATE, INDEX, and DELETE statements.
C – True. see B
D – False. see B
E – True. see B

REF: Oracle 10g Security Guide 14-2



Leave a Reply 0

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