My Oracle Support Banner

DBA Role Required By CISADM For Application Installation (Doc ID 1602243.1)

Last updated on JUNE 03, 2024

Applies to:

Oracle Real-Time Scheduler - Version 2.1.0 and later
Oracle Utilities Mobile Workforce Management - Version 2.0 and later
Oracle Utilities Framework - Version 4.2.0.0.0 and later
Oracle Utilities Meter Data Management - Version 2.1.0.2 and later
Oracle Financial Services Revenue Management and Billing - Version 2.3.0.0.0 and later
Information in this document applies to any platform.

Goal

Qn1:We are in the process of installing MWM/ORS 2.1.0. DBA Role needs to be assigned to complete the Database Installation and to apply any database related patches. Granting DBA role to an Application Schema like 'CISADM' is against the security standards for our infrastructure.

Will MWM/ORS have any issues if the DBA role is revoked from 'CISADM' once the installation has been completed?
If the DBA role is revoked from CISADM, what specific privileges need to be granted to allow CISADM to continue to perform installation tasks?

Qn2: Can the EXP_FULL_DATABASE privilege be revoked from the CISADM user? Would this affect the application?

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!

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