Post reply

Who added a login?

  • May 28, 2004 at 9:27 am

    #161587

     Hello,

    Is there a way to find out who added a sql login to a server? I'm working really hard on removing unused sql logins. But we have multiple sql admins and I see someone is adding them back.

    Thanks

  • May 28, 2004 at 11:12 am

    #508258

    Probably the only way is to run Profiler and capture the commands being run.

    -SQLBill

  • May 28, 2004 at 11:39 am

    #508261

    Thanks for your reply. I'm thinking of escalating the issue to minimize a number of DBAs. We have at least 6.

  • May 28, 2004 at 11:50 am

    #508263

    Interesting question, here we have a group of DBAs that has SA's privelege and 5 or more group of DBAs that does development work and has no SA's privelege, yet can still get their work done.  To ask who added the login would be very easy because they should have been requested by development dba.  Maybe what you need is to defind who should has SA's privilege within your company and the formality of request that could be kept track on who request the new login and who actually perform the work.

     

    mom

  • May 28, 2004 at 12:55 pm

    #508272

    Have you ASKED the other DBA's if they added the logins?

    -SQLBill

  • May 28, 2004 at 12:57 pm

    #508273

    Yes, nobody replied so far...

  • May 28, 2004 at 3:11 pm

    #508299

    What does the user account have for permissions and if no one knows for sure just disable all permissions until a user grips and tells you who added.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply