Oracle Error ORA-26854: STREAMS string has no enqueue or dequeue privileges to the queue.

Oracle Error Message

ORA-26854: STREAMS string has no enqueue or dequeue privileges to the queue.

Reason for the Error

The GoldenGate, XStream or Streams user did not have enqueue or dequeue privilege to the queue.

Solution

Grant GoldenGate, XStream or Streams user enqueue or dequeue privileges to the queue.