PrepAway - Latest Free Exam Questions & Answers

What should you do to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours?

Your SQL Server 2008 server has only the SQL Server service running. All other SQL Services are disabled. You have a user named DBReportsUser.

You need to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours. You want to achieve this goal by using the minimum amount of administrative effort and the least impact on the Server
security.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

PrepAway - Latest Free Exam Questions & Answers

A.
Use SQL Profiler.

B.
Use a logon trigger.

C.
Enable login auditing.

D.
Create a SQL Server Agent job.


Leave a Reply