Hey, there!
Actually, I've been trying to set v$session machine field. The reason is about containers. We're working with a pod that enable oracle db connection, the session sets pod's name within machine, but when pod dies the next session's machine changes.
We apply a validation over every log in to db. We use the machine field to allow interaction with tables, views, etc.
So, we need to set into machine something like: app-1.apps.openshift.com. That's the container's hostname, so if pod dies, the machine field won't change and It will continue with flow quietly.
Someone knows How to set session's machine?
I tried from oracle driver with golang & phyton, but I don't get the results I want.
I hope you can help me.
With love, Bran. <3