Oracle Web Server: accessing plsql procs through multiple users

Folks, here's my problem, I'd appreciate any help:

I'm using Oracle 8.0.4 and ows 3.0.1.

As oracle user A, I have created a plsql package to generate an html page. This works fine when I try to run the package through a simple dad and using username A.
But I would like to password-protect access to these procedures using multiple usernames/passwords, either using Oracle usernames or usernames configure through the web server's configuration. This is what I've tried so far with no success:

I created a dad to access these procedures without storing the username and password. Then I created a new username B in Oracle, I granted B the create session privilege and the execute priviledge on the plsql package. Now, if I try to access the package through user B: <host>/<dad>/plsql/A.<package>.<procedure>, I get errors about OWA and A.OWA.

Then I loaded the owa packages as Oracle user B (using owainit.sql). Now, if I try the URL again, I get a screen that simply says: "Content-type: text/html".

I've also tried fooling around with the Virtual Protection stuff in the "Configure WRB parameters for PL/SQL" but I can't get anywhere with this.

To make matters worse, the Web Server manuals have disappeared from the office. In short, Help!

Ray V.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 13:01:01 CST