I want to create new connection in a clr assembly having
- same access as the current user (ie loopback using the current user credential)
- The new connection must be outside the current transaction and changes (update/insert/delete) should not be rolled back with the transaction failure
Found solutions for both cases individually
but I want both conditions satisfied together
Basically i want to simulate autonomous connection in oracle using CLR instead of the extended stored procedure method suggested in this solution