Hello,
I'm sorry for putting this up on 3 boards but I'm unsure where it belongs and I'm desperated for help.
I've set up a Red Hat Linux 7.3 server with Apache, PHP with Oracle Functions, aswell as an Oracle client. The actual Oracle Database runs on a remote server. Everything works perfectly except for accessing certain tables in oracle... I cannot figure out how to access tables that belong (or are assigned) to other users. I log-in as SCOTT, and can access all the tables belonging to SCOTT... But if I log-in as JULY I can't access anything from SCOTT.
Is this an impossibility or do I have to add another user in the tnsnames file (I think)... I would have thought it to be possible since I can use MS Access to login as SCOTT and access things from JULY and all other users. If anyone has an Idea - please help me, and just to recap - I've compiled PHP with ORACLE functions, NOT Oracle 8 functions (so I cannot use OCI8 commands in PHP)...
Any and all help will be highly appreciated,
Gazoo...
