Post reply

is there a way to tell when a login was created or revoked?

  • July 10, 2013 at 7:56 pm

    #296232

    Hi sqlcentral colleagues - is there a way to tell when a login was created or revoked? I haven't created any triggers for this purpose. I was wondering if there's default login history info I can pull. Any hope of that? Thanks in advance.

  • July 11, 2013 at 2:24 am

    #1631490

    You can see when a login was created in the catalog view sys.server_principals.

    The default trace records events like creating or dropping a login, but keep in mind this information is not retained for a very long time as new rollover files are created. (Only the five most recently are retained by default.)

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

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

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