Link to home
Start Free TrialLog in
Avatar of BurnX
BurnX

asked on

SQL Query from Excel

I have an employee that wants to run queries from Excel 2010 on our Sage MIP Fund accounting SQL 2005 database.  Would it be a good idea to create a separate user account for the queries with just db_reader permissions, or would it be OK for him to use his normal Sage MIP user account for the queires?

I'm new to SQL and just want to make sure he can't cause any problems to the database. Sage support couldn't help with this question as it was outside their scope.  They did say to make sure not to write anything to the database as it could void support.
ASKER CERTIFIED SOLUTION
Avatar of hlaprade
hlaprade
Flag of Costa Rica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Voiding support is the least of your worries! Only give this guy read-only access - voiding of your data would be difficult to explain to your (suddenly-soon-to-be-ex)-boss !! Otherwise, do all hlaprade has said