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?
Encrypt the table's data
Create a view that does not contain the AVG_SALARY column
Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data
Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users