Impact on Clinical after revoking PUBLIC access on some packages (Doc ID 282606.1)

Last updated on JUNE 27, 2016

Applies to:

Oracle Clinical - Version: 4.0.3.49 and later   [Release: 4 and later ]
Information in this document applies to any platform.
"Checked for relevance on 20-Nov-2008"

***Checked for relevance on 07-May-2010***
***Checked for relevance on 14-Dec-2011***

Goal

Need to change privileges on specific packages due to security concerns.

If privileges on the following packages are changed from PUBLIC to an application-specific account,
what would be the impact on Oracle Clinical?

UTL_SMTP
UTL_TCP
UTL_HTTP
UTL_FILE
DBMS_RANDOM
DBMS_LOB
DBMS_JOB
DBMS_SYS_SQL
DBMS_EXPORT_EXTENSION

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms