You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance contains a database named ABC_Tester that is used by
the ABC.com’s developers. You need to allow the developers to access the SQL Server Profiler to
get traces which can be used to troubleshoot the application that ABC_Tester uses.
What action can you take to comply with this scenario?
A.
You should consider making use of Transaction Logs to grant login access to the developers.
B.
You should consider converting the database roles of the developers to a fixed database role.
C.
You should consider giving suitable server-level rights to the default SQL Server grant login
access to the developers.
D.
You should consider giving suitable server-level rights to the whole SQL Server to grant login
access to the developers.
Explanation:
You need ALTER TRACE permissions at the server level.
@see http://www.sqlservercentral.com/Forums/Topic585783-359-1.aspx