Synonyms on Queue Tables and Queues
183703Feb 15 2008 — edited Feb 26 2008The Queue is owned by ctest_owner. When i execute the update statement, the trigger fires the queue. This is working when i execute the statement as ctest_owner. But fails when i execute as application user. I believe i am missing either a privilege or synonym.
SQLL> connect ctest_app@dev
Connected.
SQL> update test
2 set start_date = start_date + 1/24
3 where test_id = 87 ;
update test
*
ERROR at line 1:
ORA-25205: the QUEUE CTEST_APP.TEST_QUE does not exist
ORA-06512: at "SYS.DBMS_AQ", line 168
ORA-06512: at "CTEST_OWNER.ENQUEUE", line 14
ORA-06512: at "CTEST_OWNER.TRG_ASSET_AU", line 5
ORA-04088: error during execution of trigger 'CTEST_OWNER.TRG_ASSET_AU'
This Queue does not reside in this schema. Do i need to create a synonym for this object?
ORA-25205: the QUEUE CTEST_APP.TEST_QUE does not exist
Thanks
-Prasad