Login | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Login

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>