This post has been wikified, any user with enough reputation can edit it.
asked
Find Not Frequently used DB users list in SQL server
Hi, I want to find the users who didn't use the SQL Database Frequently atleast 6 or more months. Then I want to disabled that users login immediately. So how can i do this using T-SQL script or SQL MANAGEMENT STUDIO. **1)Find the Not Frequently used users list in SQL server?** **2) How to disabled the users login more than 10 users login at a time?** Any kindly help me
1)Find the Not Frequently used users list in SQL server? I am not sure you can find this unless you have configured any server audit or trace running (may be extended events also). 2)How to disabled the users login more than 10 users login at a time? prepare dynamic sql that has query to disable the required login.
-- Result to text, ctrl+T
SELECT 'ALTER LOGIN '+QUOTENAME(name)+' DISABLE'+CHAR(10)+'GO'
FROM sys.syslogins
WHERE isntUser = 0
and name in ('Login1','Login2')
-- Copy the result paste in new query window then execute.
12 People are following this question.
