Post reply

who gave 'sa' to the login

  • September 13, 2012 at 5:26 pm

    #281470

    can we find out who gave 'sa' privilege to a login in sql server ?

    Note:

    -auditing is not enabled

    -dont know the approximate date, when the privilege was given

  • September 13, 2012 at 5:32 pm

    #1537582

    Sqlism (9/13/2012)

    can we find out who gave 'sa' privilege to a login in sql server ?

    Note:

    -auditing is not enabled

    -dont know the approximate date, when the privilege was given

    nope. with out some sort of auditing i dont know of a way.

    second, sa is the default Server Administrator. are you using sql authentication or windows authentication. if you are using sql authentication sa has most likely been enabled since you installed the server. with windows authentication it becomes a little harder to determine.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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