I'm a relatively new user at StackOverflow, so my apologies if I violated any rules in my post.
Here's some quick background to set the context for my question. I work as a quality analyst for a manufacturing company that stores all pertinent information about products, purchase orders, reject information, etc. in a database managed using Sage ERP X3 V6.5.
I would like to create an app that will allow us to analyze reject information in a more powerful way than is currently available. Currently, we are forced to make database connections through the Sage ERP software. I am far more comfortable with Python and feel it is a more powerful way to explore this dataset.
I am not extremely experienced in working with databases, so I have asked a higher up to setup a user with read-only access to our database through an ODBC connection. He has been fairly vague with his reasoning, but he seems to think it is not really possible to do this.
This leads me to my question: is it possible to create a user (through Sage ERP or some other medium) that has general read-only access to all of our databases? As I'm sure you can tell, I don't know a lot of the terminology for a question like this, so I'm happy to expand upon my post or answer any questions from people who respond to the best of my ability.
