Login | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


I need to find out who created a user login. syslogins gives what date/time a user was created but does not show who create it. Is there any way I can find it out? Thanks.
Unless you have SQL Profiler running to audit all security events, or unless you have the c2 audit enabled, I do not know of a way to know who created a user.
True and its better to avoid giving SYSADMIN privileges for all the users. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |