Submitting a DBMS_JOB as a specific user
439710Mar 7 2005 — edited Jan 30 2007Hi
I require a procedure to be run in the background as a specific user. A user will request a job to be run through the application front-end, such as a calculation which will be some pl/sql owned by the application user.
When the dbms_job is submitted the requested pl/sql runs, but as the user who invoked the job, not as the package owner as expected and required.
Any help, workarounds appreciated.