Re: dbms_stats & analyze table

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 16 Sep 2005 08:48:09 -0700
Message-ID: <1126885640.962703@yasure>

gl wrote:
> Pls help
>
> I have a DBA role privileges. When I try to perform
> DBMS_STATS.GATHER_INDEX_STATS on an index which belong to other user, I
> encounter insufficient privileges.
>
> But I can perform analyze table / index without any problem.

GRANT execute ON dbms_stats TO <schema_name>;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Sep 16 2005 - 10:48:09 CDT