Differences between GRANT CONNECT TO [login] and ALTER LOGIN [login] ENABLE

• 91rghf

  Default port

  Points: 1403

  More actions

  July 2, 2009 at 4:30 pm

  #211729

  The subject says it all. What is the difference between these two methods of denying a login access to a server? Are there any pros / cons to either approach?

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  July 3, 2009 at 1:08 am

  #1019639

  Hello,

  You may find these two threads of interest:-

  http://www.windows-tech.info/15/6c7783c53516a698.php

  http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/62f058c1-d0d6-4420-90e0-555794b889a4/

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• Tony Fountain

  SSCrazy

  Points: 2057

  More actions

  July 3, 2009 at 7:14 am

  #1019760

  John - Thanks for the information. These were very helpful and confirmed my thoughts on the two options.