Does streams administrator requires DBA privileges after streams replication is setup? (Doc ID 794722.1)

Last updated on MAY 15, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.

Goal

This document is intended to answer the following questions:

1. Does streams administrator user requires DBA privilege after the replication has been setup?

2. Can the DBA role be revoked after the streams replication is setup?

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