Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Privilege required to use dbms_scheduler.remove_event_queue_subscriber from another schema

GregVAug 8 2016 — edited Aug 8 2016

Hi,

The Oracle documentation about the DBMS_SCHEDULER does not say what privileges are required to use the Remove_Event_Queue_Subscriber from another schema.

In fact it does not say anything about privileges regarding this procedure or the Add_Event_Queue_Subscriber procedure:

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72385

It does for all other procedures, but not these 2 ones.

If I try to run the Remove_Event_Queue_Subscriber for a subscriber who's not in my schema, I get the insufficient privilege error.

I've tried using the DBMS_AQADM.Remove_Subscriber, but same insufficient privilege issue.

My version is 11.2.0.4.

Any idea?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2016

Added on Aug 8 2016

#database-key-features, #scheduler

1 comment

494 views