How do I grant a Sage 300 CRE user ODBC read access?

For chat assistance: Chat Now

CAUTION: The following procedure requires in-depth knowledge of database engines for your Sage product, such as Microsoft SQL Server, Pervasive SQL, and MySQL. Sage can't assist with database administration and isn't responsible for errors resulting from database changes. Back up your system and application databases required for a complete restore. Consider contacting a certified consultant or your database administrator for assistance.

 CAUTION: This solution requires advanced knowledge of Windows security and network settings. Sage isn't responsible for any issues that arise from changes to these settings. Ensure you back up all system and application databases necessary for a complete restoration. It's advisable to contact a certified consultant or your system administrator for assistance.

Grant the user ODBC read access.

1. Open Sage Desktop as Security Administrator.
2. Go to Tools, Security Administration or Options, Security Administrator.
3. Click on User Setup.
4. Locate user and identify role used for printing report that is generating the error.
5. Exit User Setup.
6. Click on Role Setup.
7. Select role previously identified.
8. Expand the ODBC box to grant read only permission to this role for the specifc tables this report pulls (ie. If error is with AP report select to allow read permissions to the appropriate AP tables).
9. Click Save.
10. Exit Role Setup.
11. Close Sage Desktop.