Forum Stats

  • 3,836,737 Users
  • 2,262,175 Discussions
  • 7,900,089 Comments

Discussions

How to configure Oracle Listener for Advanced Queuing only?

user2739689
user2739689 Member Posts: 1
edited Feb 29, 2016 7:12AM in Advanced Queueing

Hi,

is there any way to limit Oracle listener to provide AQ access only?

I mean not providing general database access through the queue provider at all.

We have the idea to configure a service to only provide AQ while the other service of that instance is available through the other listener. However did not find a way to limit the listener to only provide a specific service identified by a SERVICE_NAME rather than the whole instance with the SID.

Any advice?

Regards,

Eero

Answers

  • WGabriel
    WGabriel Member Posts: 202 Bronze Badge
    edited Feb 29, 2016 7:12AM

    Hello,

    it is not a good idea to manage a restricted AQ access only via the listener. In principle you need, of course, a database access. You could set up a dedicated db user with very restricted grants (or roles) to the corresponding AQ objects ( AQ queue, AQ queue table etc.).

    Kind regards,

    WoG

This discussion has been closed.