I have two applications say A and B both are connected to same DB using differenct users i.e. UserA and UserB. The A application is enqueuing messages in AQ such as AQ_QTAB.ENQ_UI = 'UserA'.
My spring based application(using spring AQ api) is connected with DB using UserB and listening on same AQ but I am not able see/dequeue message placed by UserA. However, if enqueue any message using UserB, it is properly dequeued by my listener.
Can any one please help me out? What sort of preliviges / propertiese I need to set.