DBMS_JOB and LOG_USER
We have a procedure, ("START_JOBS"), which executes a series of DBMS_JOBS. As part of the running of those jobs, which insert and update data, the Oracle user id is captured and stored in the table as the "last_update_user_id". The problem is, as the database is being brought up, our DBA runs this "START_JOBS" procedure as SYS, thus SYS is stored in the tables as the "last_update_user_id". I would like these jobs to execute as the schema_user, not as the log_user(SYS). I realize I could use triggers to change the LAST_UPDATE_USER_ID from SYS to the schema_user, but I was wondering if there's a way to set up the "START_JOBS" procedure to run as the schema user, and not who executes the procedure.
Thanks in advance.