What should you recommend?

You need to recommend a solution that addresses the security requirement.

What should you recommend?
A . Revoke user permissions on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.
B . Grant the users the SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views.
C . Deny the users SELECT permission on the tables. Create views that retrieve data from the tables. Grant the users the SELECT permission on the views.
D . Deny the users the SELECT permission on the tables. Create stored procedures that manipulate data. Grant the users the EXECUTE permission on the stored procedures.

View Answer

Answer: C

Explanation:

* Security Requirements

You must provide users with the ability to execute functions within the ERP application, without having direct access to the underlying tables.