PrepAway - Latest Free Exam Questions & Answers

You need 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