Topic: authenticate username/pwd using oracle stored procedure?

[timc]

I have an app that opens a new browser window to a URL that opens a PDF file at a named destination. For example:

https://www.mydomain.com/myFile.pdf#nameddest=Chapter3

I need to authenticate each user that enters this link, but preferably only once per browser session (valid until user closes browser). This authentication process needs to be performed by an oracle-database stored procedure (via a Java servlet, or other technology).

Is this possible? Anyone can outline the steps or reference a link?

The idea would be when the user enters this link, that a popup window appears asking for a username and password, which then get verified by the stored procedure, and then, and only then, the URL address is allowed to proceed.

I know I can implement password protection in `.htaccess` as follows.

AuthType Basic
AuthName "Secured Area"
AuthUserFile /path/to/.htpasswd
<Files "myFile.pdf">
Require valid-user
</Files>

But, I need this process to connect to the stored procedure to validate the user, because this stored procedure has to apply business logic to determine the users' subscription status, etc., which can change at any time.

[James Blond]

mod_authn_dbd can access the database directly... no need for scripting.

http://httpd.apache.org/docs/current/mod/mod_authn_dbd.html