Skip to Main Content

DevOps, CI/CD and Automation

Microsoft Integration Services - Enable Oracle Transactions

1000586Apr 2 2013

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 !!
Post Details
Locked on Apr 30 2013
Added on Apr 2 2013