Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to lock database users

Status
Not open for further replies.
andreis

andreis

Programmer
Apr 19, 2001
169
US
Hi, is there a script that allows me to lock (prevent from logging in) all database users (both NT and SQL Server), and then enable them back? I can do ALTER LOGIN USERNAME DISABLED, but I have about 200 users, so I'd like to have a script...
 
Sort by date Sort by votes
Run the following query and copy and paste the results back into the SQL text box:

Code: 
USE [master]
SELECT 'ALTER LOGIN ' +  [name] + ' DISABLE' FROM syslogins
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
779
Andrzejek
Andrzejek
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
565
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
888
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
1K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top