I am trying to set up a new database user to listen to a topic in our OracleAQ queue.
I have an old user set up years ago that can read and post messages to the queue.
Now I'm trying to set up a new user and it seems it doesn't have all the GRANTS needed.
What is the best way to see the differences in the GRANTS that each user has ? I'm trying to compare them to see what is different.
For example, how do I determine if this has been granted ?
grant execute on sys.dbms_aqjms to NEWUSER;