FMW RCU Based Schemas Database Compliance Violations

(Doc ID 2360069.1)

Last updated on FEBRUARY 16, 2018

Applies to:

Oracle Platform Security for Java - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Goal

Can we remove these privileges from the OPSS schema:

create procedure

propdsmis_iau

Does IAU create stored procedures at runtime for its operations? Please let us know which functionality needs this privilege so that we can decide on keeping or dropping this privilege. If this is one-time that is required at the time of install and can be disabled afterwards, please let us know.

create sequence
Does IAU create sequences at runtime for its operations? Please let us know which functionality needs this privilege so that we can decide on keeping or dropping this privilege. If this is one-time that is required at the time of install and can be disabled afterwards, please let us know.

create procedure
prodsmis_opss

Does OPSS create stored procedures at runtime for its operations? Please let us know which functionality needs this privilege so that we can decide on keeping or dropping this privilege. If this is one-time that is required at the time of install and can be disabled afterwards, please let us know.

create sequence

Does OPSS create sequences at runtime for its operations? Please let us know which functionality needs this privilege so that we can decide on keeping or dropping this privilege. If this is one-time that is required at the time of install and can be disabled afterwards, please let us know.
 

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