Re: problem from oracle to access (odbc) - Addendum

• YURYSSG --- wrote:

> I have set up an Oracle link to Access by ODBC (user = DBA)
>
> All OK, under Access I see the Oracle tables ... but I am not able to
> modify/write on them!
>
> What do I mistake?

I just noticed as a pushed the send button ... user = DBA

Are the tables you are trying to work with owned by the DBA schema? Likely they are not.
Try the following query:

SELECT table_name
FROM user_tables;

If the tables you are trying to work with are not in the result set then you may have SELECT privilege but not INSERT, UPDATE, and/or DELETE.

Finally ... what level of madness would drive anyone to give an account titled DBA to someone connecting through ODBC. Assuming DBA has DBA-like privileges ... which seems reasonable ... it would take a massive drug overdose to get any competent administrator to give you that account access.

Daniel Morgan Received on Fri Oct 04 2002 - 10:17:45 CDT