OWS 3.0.2 package protect

From: Alexey Komarov <alex_at_infor.ru>
Date: Tue, 14 Dec 1999 12:02:47 +0300
Message-ID: <83516b$1dru$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 Tue Dec 14 1999 - 03:02:47 CST