Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job failures

Re: dbms_job failures

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: 16 Jul 2001 20:38:38 GMT
Message-ID: <9ivjce$9mf@dispatch.concentric.net> 







> The package is not owned by FIT ... it is owned by FIT_DBA. Does FIT have

> execute rights?

>

> It appears not.

>




FIT does have execute rights through a role.  T. Kyte responded with



"DBMS_JOB runs with no roles enabled.  You have the ability to execute
FIT_DBA.AMS_JOB via a role."




Thanks



--
Jim Poe (jpoe_at_fulcrumit.com)


Received on Mon Jul 16 2001 - 15:38:38 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US