Re: Problem in using Oracle Web server to browse database

From: Mike Lynch <mlynch_at_us.oracle.com>
Date: 1996/12/16
Message-ID: <32b58191.56004216@newshost.us.oracle.com>#1/1

I did a search for incidents similiar to yours. Please try (or make note of) the following:

Solution/Scenario #1

---

Make sure that you have installed the Server Manager. Once the Server Manager is installed that WebServer v2.0 and PLSQL scripts will run correctly.

Solution/Scenario #2

---

DCD users can not access object owned or created by another user.

• When you grant access to one object to another user, you should also grant access to the entire htp/htf, owa, owa_init, owa_util and other owa_packages and create synonyms in the schema of USERA. With your current environment you are giving partial access. Try creating synonyms for the entire OWA packag and run your test code. Before you create synonyms you may need to drop the packages from USERA's schema.
• The user A already has priviledges to htp/htf and owa_util packages,user A should not have to have synonyms to all the PL/SQL packages that are use by USER B, i..e. use can use a procedure in user B that containts DBMS_OUTPUT.PUT_LINE from user A without any problems. Also related to the same issue calling a table owned by user B from user A does not work.

Test Case:
USER A procedure
procedure test is
num interger;
begin
select count(*) into :num from userB_table; htp.p(num);
end;
This does not work even after GRANT ALL on userB_table to user A.

• When you talk about DBMS_*** packages they are all public synonyms under SYS user. None of the OWA packages are created under SYS user. They are loaded into the specific user's schema separately. If you want to use synonyms, create public synoyms (provided you have right privileges) or as private synonyms under userA for userB's objects. OWA's architecture is guaranteed to work only if you create synonyms for the entire package and not for partial declarations.

  ---

I hope this helps,

Mike Lynch

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation.

On 16 Dec 1996 13:36:33 GMT, "Ari Kyhälä" <ajk_at_som.fi> wrote:

>For some reason I get the following error in the owa_dba.err every time I
>try to access a database thgough Oracle Web server.
>
>Mon Dec 16 15:30:05 1996
>OWS-05101: Agent : execution failed due to Oracle error 6564
>ORA-06564: object browse.intro does not exist
>ORA-06512: at "SYS.DBMS_DESCRIBE", line 55
>ORA-06512: at line 1
>
> OWA SERVICE: owa_dba
> PROCEDURE: browse.intro
> PARAMETERS:
> ===========
>
>The package BROWSE is installed and should be OK.
>
>Is there anybody out there to help me?
>
>--
> _/_/_/ _/_/_/ _/ _/ Finnish Securities and P.O.Box 926
>_/ _/ _/ _/ _/_/ _/_/ Derivatives Exchange FIN-00101
>Helsinki
> _/_/ _/ _/ _/ / _/ Clearing House Finland
> _/_/ _/ _/ _/ _/
>_/ _/ _/ _/ _/ _/ Ari Kyhala, Ajk_at_SOM.FI
> _/_/_/ _/_/_/ _/ _/ phone: +358 9 13 121220 fax: +358 9
>13121211
>
Received on Mon Dec 16 1996 - 00:00:00 CST