can't disable login

• krypto69

  SSChampion

  Points: 13604

  More actions

  February 17, 2011 at 7:19 am

  #235264

  I can't disable a login that is in one of my DB's.

  I only see the disable if the login is under 'security'.. For the logins I need to disable they are under the db's so there is no disable option.

  I thought I would use a script to disable - but that isn't working either...

  ALTER LOGIN [ADSERVER\MYUSER] DISABLE

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  February 17, 2011 at 7:46 am

  #1288241

  ALTER LOGIN [ADSERVER\MYUSER] DISABLE will disable the account for the whole SQL instance

  If you want to remove a user from a specific database:

  USE [MyDatabase]

  DROP USER [MyDomain\ThisUser]