MS Access 2007 - 11g - ODBC - ORA-01013
I have a client which accesses our databases using MS Access 2007.
We recently upgraded to Oracle 11g client on the host he accesses from and now he is getting ORA-01013 errors.
The ODBC connections are System DSNs.
Testing the ODBC connections directly through the ODBC Data Source Administrator with his account comes back with a "Success"!
The Oracle account he is using has permissions to the objects and can do what they need to at the SQL*Plus level.
From the same Windows client:
My DBA Oracle account can utilize the ODBC connection and pull back data.
His Oracle account receives an ORA-01013.
I attempted to grant him "select any dictionary" and that did not resolve the issue.
I granted him DBA privileges and his account is now able to use the ODBC connection and pull back the data required. I've removed that privilege for now since I will not be making that permanent, I just was trying to see what was different between his account and my account. So far it seems to be solely the Oracle level privileges that are different.
This worked under 10g Oracle client.
What changed between 10g and 11g clients which would require an ODBC connection to have elevated privileges in order to make a connection??
What are the newly required elevated privileges specifically?
Thank you,
Scott Crouch
DBA
UNC Chapel Hill