August 20, 2010 at 5:03 pm
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
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