A table named DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
AVG_SALARY
Which of the following is the best way to prevent most users from viewing AVG_SALARY data?
A.
Encrypt the table’s data
B.
Create a view that does not contain the AVG_SALARY column
C.
Revoke SELECT access for the AVG_SALARY column from users who should not see
AVG_SALARY data
D.
Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the
appropriate users