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?
