0 Replies Latest reply: Apr 23, 2013 3:13 AM by Franz_R RSS

    Run DBMS_SCHEDULER Job as other OS User


      is this problem known or can some one help me please?
      We use AIX 6.1 and - 64bit.
      When we create an Job it will be execute as OS User Oracle, but this is not wanted.
      The file permisions are set as described in Guide to External Jobs on 10g with dbms_scheduler e.g. scripts,batch files

      -rw-r----- 1 root dba rdbms/admin/externaljob.ora

      egrep -v '^#|^$' rdbms/admin/externaljob.ora
      run_user = nobody
      run_group = nobody

      -rwsr-x--- 1 oracle dba bin/extjob

      -rwxr-xr-x 1 oracle dba bin/extjobo

      AIX 6100-07-06-1241

      We tried different Users in the rdbms/admin/externaljob.ora file but every time the same behavior, the job runs as oracle.

      Edited by: Franz_R on 23.04.2013 01:11