Oracle Forms (MOSC)

MOSC Banner

Frm-47500 for non admin users

edited Dec 17, 2015 10:05AM in Oracle Forms (MOSC) 6 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center