What Database Objects Access Rights Required For ASAP Schema?
(Doc ID 1395384.1)
Last updated on JUNE 20, 2024
Applies to:
Oracle Communications ASAP - Version 7.0.0 and laterInformation 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
-------------------------------
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 |