Oracle WebServer User's Guide
Installing the Oracle WebServer Developer's Toolkit
To install the Developer's Toolkit, use the Oracle Web Agent Service Administration forms. Both the Service Creation and Service Modification pages provide a checkbox for installing the Developer's Toolkit. Selecting this button and submitting the form will do the following:
- grant the CONNECT and RESOURCE roles to the OWA database user For more information on these roles or on granting roles, see "GRANT (roles)" in Chapter 4 of the Oracle7 Server SQL Reference.
The OWAINS.SQL script installs all of the Developer's Toolkit packages.
Optimizing Multiple-Service Installations
If your site has multiple Web Agent services, you can minimize the amount of storage space used and enhance PL/SQL performance by doing the following:
1. Install the Developer's Toolkit in one database user's schema. This user becomes the toolkit owner.
2. Drop the Developer's Toolkit PL/SQL from the schemas of the OWA database users for other Web Agent services, if you have already installed them.
connect <user> / <password>
drop package HTF;
drop package HTP;
drop package OWA_UTIL;
drop package OWA;
3. Grant the system privilege EXECUTE on the PL/SQL packages to OWA database users for other Web Agent services. For more information on this command, see "GRANT (system privileges)" in Chapter 4 of the Oracle7 Server SQL Reference.
connect <toolkit owner> / <password>
grant execute on HTF to <user>;
grant execute on HTP to <user>;
grant execute on OWA_UTIL to <user>;
grant execute on OWA to <user>;
4. Create synonyms for the Developer's Toolkit PL/SQL packages in the schemas of all OWA database users who are specified in Web Agent services. Synonyms are alternate names that make it possible for the packages to be referred to without being qualified by schema names. For more information, see "Ownership and Naming Conventions"![[*]](jump.gif)
of this manual and see "CREATE SYNONYM" in Chapter 4 of the Oracle7 Server SQL Reference.
connect <user>/<password>
create synonym HTF for <Toolkit owner>.HTF;
create synonym HTP for <Toolkit owner>.HTP;
create synonym OWA_UTIL for <Toolkit owner>.OWA_UTIL;
create synonym OWA for <Toolkit owner>.OWA;
Security Note
PL/SQL procedures run with the privileges of the creator of the PL/SQL code. For the Developer's Toolkit, this is only an issue for the owa_util package. Two of the subprograms, showsource and tableprint, access user data. Granting execute privileges on this package to users allows those users to view the tables, views, and stored PL/SQL code of the owner of owa_util.
If this is a security issue for your installation, install the owa_util package separately for each OWA database user.
The scripts to do this are:
Both scripts reside in the OWS Administration directory, and should be run in the order listed.