Dear all
I am setting Oracle Streams AQ in test environment using Oracle 11g in Windows, but I am getting back errors at the stage of Configuring a Messaging Client to Dequeue Messages as below
SQL> BEGIN
2 DBMS_STREAMS_ADM.ADD_MESSAGE_RULE (
3 message_type => 'strmadmin.order_id_date',
4 rule_condition => ':MSG.ORDER_ID > 0',
5 streams_type => 'DEQUEUE',
6 streams_name => 'strmadmin',
7 queue_name => 'strmadmin.streams_queue');
8 END;
9 /
BEGIN
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 49
ORA-06512: at "SYS.DBMS_RULE_ADM", line 178
ORA-06512: at "SYS.DBMS_STREAMS_ADM_UTL_INVOK", line 1037
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 59
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 82
ORA-06512: at line 2
I have granted EXECUTE privilege on the SYS.DBMS_STREAMS_MESSAGING package to the Oracle Streams administrator (STRMADMIN) but still getting insufficient privileges. I don't understand what are the addition privileges needed by this command to run sucessfull?
Regards, Sadock