deny login to SQL after working hours

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

LOGON_Triggers would be one way to go and you can find a good article about how to do it here[/url].

Another option would be creating a job which disables the login(s) after working hours and enables it again in the morning.

The syntax is simply

ALTER LOGIN login_name DISABLE /ENABLE

Only thing to keep in mind is that both solutions only prevent users from making new connections. Existing connections can still be used.

[font="Verdana"]Markus Bohse[/font]

Mad-Dog SSCertifiable Points: 6117 More actions · Answer 2

OK.but how i can prevent the user from login?

by issue a rollback or there is a deny logon syntax?

THX

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

Disabling a Login will prevent the users to logon. Existing connections you need to Kill, just like it's done in the article about logon triggers.

[font="Verdana"]Markus Bohse[/font]

noeld SSC Guru Points: 96590 More actions · Answer 4

Issuing a rollback on a logon_trigger prevents the connection from succeeding.

* Noel

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 5

Hope you find this useful:

MJ