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.