You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance hosts quite a few applications. ABC users report that one
of the applications has stopped working.
An application developer named Mia Hamm has been assigned to troubleshoot the application.
You need to provide Mia Hamm with only the permissions required for her to perform this task.
What steps should you take?
A.
You should assign the required database-level permissions to Mia Hamm’s SQL Server login.
B.
You should assign the required server-level permissions to Mia Hamm’s SQL Server login.
C.
You should assign the required object-level permissions to Mia Hamm’s SQL Server login.
D.
You should makeMia Hamm’s SQL Server login a member of the db_owner role.
Explanation: