Frm-47500 for non admin users
Hello,
I did create advanced queue with our user "admin".
For this i did grant this user the role "aq_administrator_role".
Another user "test" did get the role "aq_user_role".
I did create an object type, which will be the payload_type of the multi consumer queue that i did create.
I did also grant type access using the dbms_aqadm package to specific user, "admin" and "test", aswell as
i did grant the system_privelege to enqueue and dequeue any queue to both of the users using the "admin" user.
Following i did add both users as subscribers to the queue.