Re: Oracle Logon from a Web Server

Why not let the users select their own Oracle passwords. Just give them the ability to change their Oracle password and they can keep their passwords in sync even if their logon password is generated and assigned automatically by the system.

regards

Jerry Gitomer

Cristóbal García wrote in message <373c3cff_at_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:34:56 CDT