My Oracle Support Banner

What Database Objects Access Rights Required For ASAP Schema? (Doc ID 1395384.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Communications ASAP - Version 7.0.0 and later
Information in this document applies to any platform.

Goal

 

ASAP database schema got different privileges which were given at the time of ASAP product installation. Now, the privileges are being reviewed and find that the privileges are SYS privileges. The privileges are mentioned below. 

SARM schema privileges:
-------------------------------

CREATE ANY MATERIALIZED VIEW
CREATE OPERATOR
CREATE ANY TABLE
CREATE ANY TRIGGER
EXECUTE ANY PROCEDURE
ANALYZE ANY DICTIONARY
CREATE ANY INDEX
CREATE ANY PROCEDURE
CREATE PUBLIC SYNONYM
ANALYZE ANY
CREATE ANY SYNONYM

ADM, CTRL, NEP, SRP schema privileges:
----------------------------------------------------

EXECUTE ANY PROCEDURE
CREATE OPERATOR
CREATE ANY MATERIALIZED VIEW
CREATE ANY INDEX
CREATE ANY SYNONYM
CREATE ANY TABLE
CREATE PUBLIC SYNONYM
CREATE ANY TRIGGER
CREATE ANY PROCEDURE  

Can these privileges be revoked or not?

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
References


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