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.
]]>

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 |