petelai100
asked on
Access ODBC to Oracle Database - Read Only
Hi Experts,
I have access application which needs to connect to an Oracle database using ODBC. What is the best and most secure method of connecting to the database with 'Read Only' rights? The application will run on multiple computers if that makes any difference. The reason I need Read Only access is to satisfy J-sox requirements.
Thanks in advance
Peter
I have access application which needs to connect to an Oracle database using ODBC. What is the best and most secure method of connecting to the database with 'Read Only' rights? The application will run on multiple computers if that makes any difference. The reason I need Read Only access is to satisfy J-sox requirements.
Thanks in advance
Peter
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
TheVeee
Additionally if you decide not to use odbc and go the jndi route for a web application, the only needed knowledge is the userid and password, the security is still the same via oracle security. As long as the user is valid, Oracle "knows" what table the user can read or maintain without regards how the user connected via odbc, jdni or anything else....
ASKER
Hi the application will also be using an SQL database. Would it be better to have the SQL database connect to the oracle server as opposed to multiple computers? Can it be done?
Thanks again
Peter
Thanks again
Peter
Hmm not following you on that one? Applications connect to each other, not databases. So whats your definition of a oracle server? Our you talking the Oracle Database, or our you talking about the Oracle container AKA Oracle web server?
So if your asking can a SQL Server Database talk directly to a Oracle database, the answer would be no. Databases can only talk to each other when there the same type... aka clustering. To my knowledge no manufacture lets you cluster two different types of databases by different vendors.
If your asking if the Oracle container (web server) can talk to SQL Server Database it would think it would be possible but would take alot of customization. And if the later is true the Oracle Container attaching to the SQL Server Database, why would you want to spend the large amount of money for licensing fees when the Apache server could do this for free?
So if your asking can a SQL Server Database talk directly to a Oracle database, the answer would be no. Databases can only talk to each other when there the same type... aka clustering. To my knowledge no manufacture lets you cluster two different types of databases by different vendors.
If your asking if the Oracle container (web server) can talk to SQL Server Database it would think it would be possible but would take alot of customization. And if the later is true the Oracle Container attaching to the SQL Server Database, why would you want to spend the large amount of money for licensing fees when the Apache server could do this for free?