:::: MENU ::::

Disable log in of a user in SQL Server

  • Mar 04 / 2009
  • 0
dbDigger, Logins and Users, Security and Permissions, SSMS tips and tricks

Disable log in of a user in SQL Server

It may be required to disable the account of a database user in various scenarios. In SQL Server 2000 we had no such option to disable a database user. From SQL Server 2005 and onwards there is an option to disable the log in of a database user.

  • Under security folder of your SQL Server instance, find and right click the user to whom you want to deny the login permission to SQL Server.
  • Right click the user and click properties
  • Following frame will be displayed, Go to status options

Deny LogIn for SQL Server User

Now click OK and the selected user is no more able to log in to SQL Server.

Consult us to explore the Databases. Contact us