Need To Revoke Risky Privileges From Network Intelligence Application (Doc ID 1308844.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Goal

We are in a process of production deployment of NETWORK INTELLIGENCE. As per the installation guide, along with other database privileges, following privileges are also required which we need to revoke -

DB User: NETINTEL_CORE

DROP ANY VIEW
DROP ANY TABLE
DROP ANY TRIGGER
CREATE ANY SYNONYM
CREATE ANY TRIGGER
DROP ANY DIRECTORY
DROP ANY PROCEDURE
CREATE ANY DIRECTORY
DROP PUBLIC DATABASE LINK
DROP ANY MATERIALIZED VIEW



DB User: NETINTEL_STG

DROP ANY VIEW
DROP ANY TABLE
DROP ANY TRIGGER
CREATE ANY SYNONYM
CREATE ANY TRIGGER
DROP ANY DIRECTORY
DROP ANY PROCEDURE
CREATE ANY DIRECTORY
DROP PUBLIC DATABASE LINK
DROP ANY MATERIALIZED VIEW


Please confirm if it is possible or not or any work around is available.

Please note that this is a company level security policy requirement so we require to do this change management.

Solution

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