Database Software

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!

Unable to grant privileges to enque or deque

532030Sep 5 2006 — edited Sep 7 2006

Hi ...
I am new to AQ. I am trying to send a notification mail using JMS when something changes in the database. I am just going through a guide for the beginers. ie
http://www.oracle.com/technology/products/ias/toplink/technical/tips/DbChangeNotification/index.htm

I connected to the database as system admin.But I am unable to grant previleges to any general user. I am getting "ORA-00900 invalid SQL statement" error.

How can I set up the environment for Advanced Queuing and How can I resolve this issue?

I would appreciate any help or relevant material to accomplish my task.

Thanks and Regards,
Prince.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2006

Added on Sep 5 2006

#advanced-queueing, #database-key-features

7 comments

2,245 views