Disabling SQL Server Logins in SQL Server 2005

In this video Brian covers disabling sql server logins and the different options available when disabling logins.

Brian is a SQL Server author, columnist, and MVP focusing primarily on SQL Server security. He currently serves as database administrator / architect at AgFirst Farm Credit Bank where he can focus on his passion: SQL Server. He formerly served as a systems and security architect for AgFirst Farm Credit Bank where he worked on Active Directory, Windows security, VMware, and Citrix. In the technical...

lewis on 9/28/2009

great

Mark Weichman on 9/28/2009

Given your presentation, what is the need for 'enable/disable'...we could just allow/block activity against the database with the grant/deny login feature

Loren Foster on 9/28/2009

The very best explanation ever on this topic.

Felekech Tigabu on 9/28/2009

very good.

Stephen Oesterreicher on 9/28/2009

What is the difference between a Windows Login and Group Login?

Diana Dee on 9/28/2009

Could you please tell me why you could not simply remove the CONNECT SERVER permission (i.e. a REVOKE not a DENY) for the Windows Group login? This would avoid the problem of Deny trumping any other Grant for a Windows user that is a member of another group having a SQL Windows login. DrDianaDee@verizon.net -- Thanks!

Pradeep Kumar Satapathy on 9/28/2009

excellent

Udayakumar Rathinam on 9/28/2009

Useful refresh.

nilanaksha on 9/28/2009

Good example to explain...

Tonci on 9/29/2009

Simple and to the point.