You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB01 in the instance. The company CIO wants all the application developers can capture traces to troubleshoot the application that uses the database DB1, and they can perform this by using SQL Server Profiler. But they have to be given as little permission as possible. The company CIO assigns this task to you. So what action should you perform to achieve this goal?()
- A、All the SQL Server logins of the application developers have to be added to a fixed server role.
- B、All the database users of the application developers have to be added to a fixed database role
- C、All SQL Server logins of the application developers should be given the appropriate server-level permissions.
- D、All database users of the application developers should be given the appropriate database-level permissions.
正确答案:C
答案解析:有
微信扫一扫手机做题