Re: Streams DBA Role

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: moabrivers@xxxxxxxxx
  • Date: Tue, 5 Jun 2007 19:55:31 +0100

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@xxxxxxxxx> 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?

Other related posts: