OWS 3.0.2 package protect

From: Alexey Komarov <alex_at_infor.ru>
Date: Mon, 13 Dec 1999 10:55:14 +0300
Message-ID: <8328rn$2hp$1@news.radio-msu.net>

Hi.
Situation: User USR1 owns some procedures that can be executed by USR2. PL/SQL Agent is configured for access to USR2 packages.

Problem: The problem is to protect packages and procedures owned by user USR1
from being executed directly by URL configured for access to PL/SQL procedures of USR2.
The part of OWS documentation says “The PL/SQL Cartridge lets you enforce this by protecting
packages. A protected package can only be executed by another stored procedure,
not directly by a URL. By default, all the OWA utilities provided with the Web Application Server are protected. Other packages are by default unprotected.
To override the default, use the PL/SQL Cartridge configuration section of the Web Application
Server Manager to change the package_protect parameter.”

Parameter “owa_pkg_protect” has two values: TRUE|FALSE, and protects only OWA utilities, am I wrong? Could you help me to enable protection for packages
others then OWA utilities provided with the Web Application Server? Received on Mon Dec 13 1999 - 01:55:14 CST