PL/SQL (MOSC)

MOSC Banner

DBMS_AQADM.PURGE_QUEUE_TABLE security model

in PL/SQL (MOSC) 4 commentsAnswered ✓

Hi.

If I am not mistaken, DBMS_AQADM.PURGE_QUEUE_TABLE can be run only by the owner of the queue table, and his security model runs under INVOKER's RIGHT model.

This implies that nobody, except the queue owner, can use the procedure, even if the call is wrapped in a program owned by the queue owner.

Am I wrong? Is there any way to implement a procedure capable of cleaning a given queue before and after using it?

My scenario is:

queue XXX is used to forward messages between a controller job and several slave job;

when you start the controller job, it creates the slaves and start sending messages;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center