ORA-01031: insufficient privileges
edited Oct 22, 2016 5:00AM in GoldenGate, Streams and Distributed Database (MOSC) 6 commentsAnswered
Hi
I need help. I setting Oracle Streams AQ in 11gR2 ruunning in Windows. I have granted privileges granted by the
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
I need help. I setting Oracle Streams AQ in 11gR2 ruunning in Windows. I have granted privileges granted by the
GRANT_ADMIN_PRIVILEGES procedure in the DBMS_STREAM_ADM package using execute DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE('STRMADMIN') statement but still I am getting errors of insufficient prilelege as followsSQL> 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
1