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?