linked tables to Oracle-error handling

[trialerror]

My application has an access 2003 front-end and Oracle 9i backend( tables are linked). When I connect I get the standard connect box to enter in Oracle SID,username , pwd. This works fine when I connect as "system", but when I connect as any other user like Scott, I get a bunch of errors. I would like to customize the error when I login as a non-dba user to say that "login denied" etc. I cant understand where the connnect parameters are stored in Access? Thanks.

 

[willir]

trialerror
You may need to discuss this issue with the Oracle DBA. Oracle has far better security, and the described problem suggests you are running into an Oracle setup / security problem.

Richard

 

[trialerror]

The application links to "dba tables" and thats why the dba or system user can connect fine. But if some other user attempts to connect, I simply want to have a MsgBox saying "login denied" etc. after the user puts in username/pwd in the Oracle ODBC Driver Connect box.Thanks

 

[trialerror]

Also, when I get the login box-the Oracle ODBC driver connect, and I hit Cancel, the box comes up back again. This happens every time I hit Cancel and I have to eventually close the application, if I wish to quit. Any suggestions would be helpful.