Post reply

How to block 3rd party tool in accessing MS Database

  • November 12, 2009 at 3:05 am

    #385773

    hi

    I am having the server in a place and some 10 of us have installed SQL client,so we access the data no problem. But some of non DB persons uses the tool and they too modify.we are all connected to LAN

    Is there way to block others using the server by tools.

    We client users use sa password and the sa password is sent to non db persons to access the data.

    I created users and give to them to access the data from front end, but they are changing the datas by using that Tool in there logins as well as SA login .Is there way to block that Tool.If so how

    Thanks

    Parthi

    Thanks
    Parthi

  • November 12, 2009 at 4:08 am

    #1078242

    I wouldn't think so....you should create an application role and use that for access, you certainly should not be handing out SA passwords if you want to retain any type of security at all.

  • November 12, 2009 at 5:00 am

    #1078257

    SA pwd should never be given to all the users. Its a bad practice. You can create a application role and manage user permissions as the previous post suggested or you can create different users and then give the required permissions to those users. Or if you have a set of users that need common permissions you can create a role and add the users to that role.

    "Keep Trying"

  • November 12, 2009 at 5:15 am

    #1078266

    I think you need login trigger if you want to avoid any particular type of third party tool. Follow this link. Thanks.

    http://www.sqlservercentral.com/Forums/Topic812192-145-1.aspx

    ---------------------------------------------------------------------------------

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

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