The other thing I had to do for a user was to add a bunch of Sage user authorization privileges. So, the question is how can I efficiently determine which authorizations privileges I will need to run a crystal report. The problem is that the set of privileges that worked for Sage 2012 does not work with the same report for Sage 2020 which doesn't make any sense to me. If the authorization privileges are insufficient, the behavior is that Sage might crash or else the program does not complete. 

If you have to mess with privileges, then your reports aren't written correctly.  Never use NT authentication, always use login and password inside the Crystal editor.

If you have to mess with privileges, then your reports aren't written correctly.  Never use NT authentication, always use login and password inside the Crystal editor.

please expand on this. When I changed the reports, I had to enter the sa username and password when connecting to the database in Crystal. 

That's correct.  So I don't know what privileges you're referring to.

In the administrative services group, there are user authorizations on a sage user by user basis. The admin user is authorized for everything, but other users may be locked out of a module or certain functions of a module like approve to pay. I was not able to read the IC file unless some IC group authorizations were turned on. The problem is that which modules should I authorize and which functions for a given report. It's not as if there is a documented mapping somewhere that says you have to have "this authorization" to be able to read "that table".  

I never heard of that before.