Skip to Main Content

SQL & PL/SQL

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!

synonyms for oracle queues

663276Jan 7 2009 — edited Jun 8 2009
hi,

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2009
Added on Jan 7 2009
2 comments
1,532 views