You administer a SQL Server 2008 instance. The instance contains a database named DB1.
You plan to allow all the application developers to use SQL Server Profiler to capture traces
to troubleshoot the application that uses the database DB1.
You need to grant the minimum necessary permission to the application developers.
What should you do?
A.
Grant the appropriate database-level permissions to all database users of the application
developers.
B.
Grant the appropriate server-level permissions to all SQL Server logins of the application
developers.
C.
Add all the database users of the application developers to a fixed database role.
D.
Add all the SQL Server logins of the application developers to a fixed server role.
alter trace permission is needed