OWAS public access
Date: 1998/04/27
Message-ID: <6i3g2g$ivb$1_at_excalibur.flash.net>#1/1
Hi Ya'll:
I would like to create one DAD and one PL/SQL agent that I can use to call stored procedures from different schemas. I'm using owas 3.01
I setup a test with two users. User 1 called 'pub' and user 2 called 'USERA'. Here is what I've done.
- create a DAD with user 'pub' and it's password stored in the DAD
- create a PL/SQL agent 'pubagent' using the DAD above called 'pub'. - had webserver utilitiy create owa.utils package in user pub account.
- create synonyms for owa.utils package in USERA account from 'pub' account
- granted execute on owa.utils package for USERA
- created a procedure create or replace procedure USERA.TEST as begin htp.p ('procedure in USERA<br>'); end;
- granted user 'pub' execute on procedure object 'USERA.TEST'
- called my procedure from the web using http://www.mydomain.com/pub/plsql/usera.test
This returns a web page with just one thing on it: Content-type: text/html
[Here is what has worked]
8) if a create the same procedure 'test' in the schema 'PUB' it works fine.
9) i also created another DAD and AGENT that did not have user and password
stored in the DAD. When I called the URL it prompted for a user name and
password, i put in USERA and password for USERA account. It ran the
USERA.TEST just fine.
How can I get my 'public' agent to call procedures from another schema?
Thanks!
Juan
Received on Mon Apr 27 1998 - 00:00:00 CEST