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!

AQ_ADMINISTRATOR_ROLE and DBMS_AQADM

rahulrasMay 27 2008 — edited May 28 2008

Hi,

I am on 10.2 on Linux.

My user has AQ_ADMINISTRATOR_ROLE role granted and on sql prompt if I describe dbms_aqadm, I can see the details.

But when I try to execute dbms_aqadm or try to compile a procedure which calls dbms_adaqm, I get error, "PLS-00201: identifier 'DBMS_AQADM' must be declared".

I know that, on packages and procedures, we need to grant the "execute" privilege explicitely to the user.

But then, what does the AQ_ADMINISTRATOR_ROLE stands for ?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2008

Added on May 27 2008

#advanced-queueing, #database-key-features

2 comments

4,865 views