Scheduler jobs run as creator instead of owner

From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Mon, 3 Nov 2008 10:16:45 -0600 (CST)
Message-ID: <459903942412d465893eee47da3dc272.squirrel@society.servebeer.com>


Hey all,

In 10.1.0.5.0, I've been moving some Scheduler jobs from my user to a generic Scheduler schema. I created this generic schema with an invalid password for security's sake.

So, I login to my DBA account (not SYSDBA) with CREATE ANY JOB priv and create the program, schedule, and job, specifying the owner of each to be the new generic schema. However, Grid Control says the new jobs are running under my DBA account instead of the owner of the program/schedule/job. This isn't a showstopper, but highly undesirable for some hopefully obvious reasons.

Has anyone else seen this? Metalink doesn't seem to have any related hits.

TIA,
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 03 2008 - 10:16:45 CST

Original text of this message