QuestionQ91

VerifiedData and Database Security

An account manager with employee ID number 0012 has resigned from an organization. The account manager’s view privileges must be removed from the customer table. Which command is the best option for the organization’s database administrator to use to complete this task?

Explanation

The SELECT privilege authorizes viewing data in a table. Revoking SELECT on tblCustomer from employee ID 0012 removes that account’s ability to view the customer table.

Community Discussion

No comments yet. Be the first to start the discussion!