My Oracle Support Banner

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

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Clinical - Version 4.0.3.49 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.