Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MS Access 2007 - 11g - ODBC - ORA-01013

user10430831Jan 14 2013 — edited Jan 15 2013
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
This post has been answered by gdarling - oracle on Jan 14 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2013
Added on Jan 14 2013
4 comments
6,693 views