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 - dbms_stats

Re: dbms_job - dbms_stats

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 28 Mar 2003 12:13:26 -0600
Message-ID: <23498vsrsdkgh5ra5k0e1afpehsas5phtb@4ax.com> 





On Fri, 28 Mar 2003 12:53:39 -0500, "Roger Roach" <rroach_at_pwrplan.com>
wrote:



>Try granting Execute to the System user on the procedure, because all the

>roles will get strip from the user

>

>when running a submitted job.




Hmm.  If one starts down that road -- granting privileges directly to
users -- doesn't that start to negate the use of roles?  Seems that
'best practices' would go a different direction.
Received on Fri Mar 28 2003 - 12:13:26 CST












Original text of this message













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