SQL Server Performance Forum – Threads Archive
LoginI 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.