Re: Streams DBA Role

From: David Sharples <davidsharples_at_gmail.com>
Date: Tue, 5 Jun 2007 19:55:31 +0100
Message-ID: <be592d550706051155ud2400ffm81475cd4696f3a81@mail.gmail.com>

it never did, you just need

SELECT_CATALOG_ROLE

GRANT EXECUTE ON DBMS_AQADM
GRANT EXECUTE ON DBMS_CAPTURE_ADM
GRANT EXECUTE ON DBMS_PROPAGATION_ADM
GRANT EXECUTE ON DBMS_STREAMS_ADM

GRANT EXECUTE ON DBMS_APPLY_ADM
GRANT EXECUTE ON DBMS_FLASHBACK On 05/06/07, Brian Lucas <moabrivers_at_gmail.com> wrote:
>
> Can someone tell me if the streams administrator on a remote site -- that
> only applies changes it receives and never captures -- must have the DBA
> role in a 10g streams environment? If it's needed for initial setup, can it
> be revoked without breaking the stream?
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 05 2007 - 13:55:31 CDT