Post reply

Linked Server security

  • August 20, 2010 at 5:03 pm

    #222969

    Greetings all,

    I have a vendor provided database called Database1 on SERVER1. The users log in to the vendors app with SQL users logins. The vendors has overprivileged the users meaning if a user was to log directly into the database via a query tool they would have a dangerous amount of power.

    I do want to give certain users access to the data outside the application probably through MS Query in excel. Any suggestions on how to do this while minimizing risk?

    One idea I had was to give the users access to another db server (SERVER2) and then create a linked server back to SERVER1/Database1. Will this provide more security?

    Comments welcome...

  • August 22, 2010 at 9:39 pm

    #1210218

    One way I generally achieve this is by setting the default database for those users to a database that they dont have access to. for e.g. Database2(they DONOT have access to this database).

    This prevents them logging in directly to SQL through management studio.

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

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