DS0-001: CompTIA DataSys+Demo

By CompTIA · Question Mode

QuestionQ91

Data 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?

  • A REVOKE SELECT -ON tblCustomer -FROM '0012'
  • B REVOKE DELETE -ON tblCustomer -FROM '0012'
  • C REVOKE UPDATE -ON tblCustomer -FROM '0012'
  • D UPDATE TABLE tblCustomer -DROP SELECT -FROM '0012'
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!