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.)

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.)

A.
Use SQL Profiler.

B.
Use a logon trigger.

C.
Enable login auditing.

D.
Create a SQL Server Agent job.



Leave a Reply 0

Your email address will not be published. Required fields are marked *