Post reply

Check unauthorized access

  • April 4, 2012 at 5:40 pm

    #254273

    Hi All,

    I needed to check if there are any unauthorized accesses on SQL Server for security. I have created an audit which would show all successful logins. I wanted to know if this is the way to do it.

    Please let me know your thoughts.

    Esha

  • April 5, 2012 at 7:36 am

    #1469497

    I would probably audit failed logins as well so you can see who is trying to access the server in an unauthorized manner.

    Also can you define unauthorized access? If a person successfully logs in then they are authorized to access the server.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • April 5, 2012 at 7:57 am

    #1469528

    Unauthorized access is in the control of the DBA, no? If I say user1 can access the DB, then user1 can access the DB.

    If i do NOT add user2 as a login, then user2 cannot access the DB.

    Jack is right though. You might be looking for Failed Logins which will show an Unauthorized attempt to access the DB.

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

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