I'm using Apache::DBI, DBI and DBD::Oracle

The database connection is made with one username/password for best
performance but a pl/sql program in the database authorizes the supplied
username and password and then generates the desired output.

The username and password has been obtained using basic authentication
with Apache::AuthAny (pp 282-285 Apache Modules with Perl & C - Stein &
MacEachern).

Possible solutions might be:

1) connect and authorize using the authentication handler and pass the
database handle to the script to do further operations on the opened
connection. If this is possible how would you pass the database handle
from the authentication handler to the perl program?

2) Allow the perl program to return DECLINED or AUTH_REQUIRED to Apache.
How would you do this?

Thanks,
John Russell

Reply via email to