synonyms for oracle queues
663276Jan 7 2009 — edited Jun 8 2009hi,
We have the following set up in place,
A Schema user(say user1) who owns all tables, procedures, queues. And a user(say user2) who accesses these objects using synonyms.
User2 is able to create synonyms and has been granted enqueue/dequeue permissions for the queue owned by user1.
now user2 executes a plsql procedure invoking these queues, but this gives an error stating user2.queue-name not found.
if the same plsql procedure is modified to prefix user1.queue-name then the procedure runs successfully.
Are synonyms valid for oracle queues? any ideas to make things work?