As part of setting up the Oracle Fusion Middleware 12c SOA suite, Repository Creation Utility is being installed for setting up the Database.
- 1."Prepare Scripts for System Load" option was used for RCU set up (user has limited previlages)
- Scripts were generated for the DBA to execute it later on
In the generated scripts, there are few roles including Dbms_aqadm, aq_administrator_role for which admin privileges are assigned. Since the client uses a shared DB server and there are stringent policies on access, customer has raised a concern and wanted to know
If the privileges can be revoked post FMW installation (this includes SOA, OSB and MFT).
(ii) Change the specified unlimited tablespace allocations
(iii)Change the dbms_scheduler to be managed by Control-M
Please provide your inputs