0

Oracle DB connection to Excel via ODBC is possible

e.g. Developer can create Excel. Get Data. from Database. Oracle. It asks for Server, SQL statement. and this ODBC works well.

however, Consumer needs DB login / password to pull this data. If we dont want to share login / password but integrated into Excel, how to do this?

Improve this question
2
  • Save the data in an Excel file? I'm not sure what else you expect to be able to do, here. Commented Apr 29 at 2:03
  • As long as the user you are logging in as only has Read access to the specific tables you're accessing, then having the User/PW visible should not be an issue. If you want to lock things down even further, create a View in Oracle and only grant access to that specific View. Or you could create a Procedure to pull the data. Lots of ways to keep your data while still granting access to the info you need. Commented Apr 29 at 13:37
Related questions
2191
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
0
Oracle (on server) - Excel connection
1
Force Excel to exclude UID in connection string on ODBC Data Connection?
Load 3 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.