Oracle Logon from a Web Server

From: Cristóbal García <cgg_at_unica.edu>
Date: Fri, 14 May 1999 17:13:51 +0200
Message-ID: <373c3cff@ariadna.adam.es>

Hello to all!

    I work on a University in Spain and we're testing Oracle 8.0.5 under Linux in order to buy it if it fits our requirements.

    At now we're developing a set of software components which works on an intranet fashion. For example all the admittance control software works via WebClient (forms, queries against a RDBMS, etc) (no java).

    We are using mysql as DBMS (mmmh) and NIS to authenticate users. We like to use Oracle in the next way:

    1.- Define the user privileges for data at DBMS level (grants, ...)
    2.- Use the apache htaccess file for access-control
    3.- Login to the database with the REMOTE_USER and REMOTE_PASSWORD

variables passed to a "CGI" (php really) by apache.

    We'd like to do it this way because of the privilege control is very reliable if done by Oracle and not so if done at CGI.

    The problem is we've got 1000 (less or so) users and all of them must access to the DB in some way. If NIS can be used to authenticate them they won't need remeber two passwords: one for the intrantet and one for the DB
(we don't like changing two passwords to save them remembering it)

    I've created an user OPS$cgg and it's correctly authenticated if I logon from sqlplus with no username but if I try to do a Logon from a CGI with OPS$cgg and the password of that user denys access
(idem for cgg, the real user login name).

    Well, the last thing to say is that i've read the manuals all I can but I must say they are overcoming me.

    Thanx a lot.

    Cristóbal Received on Fri May 14 1999 - 10:13:51 CDT