I am trying to get and understanding of the security with SQL and GP. Unfortunately, I know alot about GP but virtually nothing of SQL. Our IT person handles the SQL side. The confusion I am running into with with some of these new tools with GP10 there are rights you have to have to deploy these things. I am not allowed access to SQL only what I have through access to GP. My IT person says that we cannot have any rights to SQL because that would open us up to the entire database. We are housing more than just GP databases on the SQL2005 Server. Are we mising something with security to be able to effectively utilize more tools/functionality with GP? I hope this makes sense. We have not upgraded to 10 yet but will be mid-September and I would like to get some clarification about security. I do not have the SA password. Do other companies allow someone in the finance department (we are the main users of GP right now) have that SA distinction. Sorry for the length but I am trying to understand this very confusing issue. Our IT people have not been trained in the realtionshop of SQL and GP. They only have the SQL knowledge. I feel we have a communication gap. Any suggestions?
