Re: dbms_job - dbms_stats

On Fri, 28 Mar 2003 12:13:26 -0600, Ed Stevens <nospam_at_noway.nohow> wrote:

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

They would define the procedure with authid current_user

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 28 2003 - 14:00:57 CST