Forum Stats

  • 3,783,382 Users
  • 2,254,767 Discussions
  • 7,880,376 Comments

Discussions

Microsoft Integration Services - Enable Oracle Transactions

Hi,

I have an applications on Microsoft Transaction Services, built using ETLs. The applications works fine when the transactions options are disabled, but when I active this feature I have an error saying than the connection could not be established because the connection is not well configured or the user hasn't the required grants. When I grant the user to sysdba, the applications works with the transactions options enabled.

Can anybody tell me wich are the specific grants that I have to assign to the oracle connection user?

Thanks a lot !!
This discussion has been closed.