How to make SQL or Oracle DB updates in an action script?

(imported topic written by drbyars91)

Not sure if anyone has tackled this or not, I could not find any similar posts or threads.

I have an action script I am running against a handful of servers that upgrades a custom application, collateral files, COM objects, etc. I’d like to also include my DB schema changes so that everything is contained within BigFix actions.

My issue of course is that the local system account that the action runs under does not have privs to the Oracle database. RunAsCurrentUser is not desirable since I’m trying to avoid having anyone logged into the system at the time of upgrade.

Are there any examples where someone has successfully manipulated database schema or content via an action script?

I’m going to dig deeper to see if I can use the Windows ‘runas’ utility to launch a script with an account that has privs on the DB. In this case I have the benefit of the DB resides on the same system but I’ve got other examples where this will not be the case.