Your database has a strict security requirement that whenever users select from any table in the database
schema, they must append the select statement with an additional where predicate that returns only records
WHERE owner = :pUserName. This restricts users to seeing only records that they own.
When you design and develop the ADF Business Components in your ADF application, there will be more than
100 view objects that select against this database. You want to build a solution that not only ensures all your
developers, when writing view objects, meet the database’s strict security requirement, but takes the least
amount of development effort for your entire team and is easy to maintain in the long term.
Identify the correct solution. (Choose the best answer.)
A.
Define a view criteria on each view object at design time to apply the predicate to the corresponding view
object, ensuring the view criteria is defined against the view object instance in the Application Module Editor.
B.
Override each view object’s ViewObjectImpl class methods to programmatically modify each viewobject’s where clause at run time to add the predicate to the select clause regardless of the query
executed.
C.
Create a complete set of custom ADF Business Component framework classes for your business
components and then override your custom ViewObjectImpl class to programmatically modify each view
object’s where clause at run time to append the predicate.
D.
In each view object, simply type the predicate into the WHERE clause of the View Object Editor query page.