PrepAway - Latest Free Exam Questions & Answers

You need to grant the minimum necessary permission to the application developers

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?

PrepAway - Latest Free Exam Questions & Answers

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.

One Comment on “You need to grant the minimum necessary permission to the application developers


Leave a Reply