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

Last updated on MAY 09, 2011

Applies to:

Oracle Communications Network Intelligence - Version: 3.3.0 and later   [Release: 3.3.0 and later ]
Information in this document applies to any platform.

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

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