Sql server：跟踪谁更改了登录密码 [英] Sql server: track who changed login password

问题描述

大家好，

我想跟踪谁（PC名称/ IP）已更改我的SQL Server上的登录密码是否有任何查询或处理请帮助。



我尝试了什么：



我用Google搜索但没有找到任何帮助。

Hi All,
I want to track who(PC name/ IP) changed Login password on my SQL Server is there any query or process please help.

What I have tried:

I have googled but found no help.

推荐答案

请先阅读我的评论。



没有机会找出谁更改了MS SQL Server的密码。但您可以跟踪更改日期。请参阅：

跟踪登录密码更改SQL Server [ ^ ]

[求助]确定更改了SA密码的人 - Microsoft SQL Server - Spiceworks [ ^ ]

最后一次更改SQL Server sa密码是什么时候？ [ ^ ]

< a href =http：//dba.s tackexchange.com/questions/56930/is-there-a-way-to-find-out-who-changed-the-password-for-a-login\">sql server 2008 r2 - 有没有办法找出谁更改了登录密码？ - 数据库管理员堆栈交换 [ ^ ]



我建议创建一组登录或单次登录，具有写入/读取/编辑/删除数据的最小权限。不添加更改登录详细信息，更改SQL Server对象等的权限。

Please, read my comment first.

There's no chance to find out who's changed password to MS SQL Server. But you can track the date of change. See:
Tracking Login Password Changes in SQL Server[^]
[SOLVED] Determine who changed SA password - Microsoft SQL Server - Spiceworks[^]
When was the last time the SQL Server sa password changed?[^]
sql server 2008 r2 - Is there a way to find out who changed the password for a login? - Database Administrators Stack Exchange[^]

I'd recommend to create a group of logins or single login with minimum permission to write/read/edit/delete data. Do not add permission to change login's details, change SQL Server objects, etc.

您也可以借助这些链接

SQL SERVER - 谁更改了SQL登录密码？ - 本周访谈问题＃065 - Pinal Dave的SQL权威之旅 [ ^ ]

跟踪SQL Server中的登录密码更改 [ ^ ]

如果密码改变了如何知道谁更改了2005标准版本，如何跟踪sqlserver登录[ ^ ]

you can also take the help of these links
SQL SERVER - Who Changed the Password of SQL Login? - Interview Question of the Week #065 - Journey to SQL Authority with Pinal Dave[^]
Tracking Login Password Changes in SQL Server[^]
How to track a sqlserver login if password changed how to know who has changed its a 2005 standard edition[^]

这篇关于Sql server：跟踪谁更改了登录密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！