Re: dbms_stats & analyze table

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 16 Sep 2005 13:30:46 GMT
Message-ID: <Xns96D3424043C5SunnySD@68.6.19.6>

"gl" <gavin_at_cagamas.com.my> wrote in
news:1126862040.621563.131280_at_z14g2000cwz.googlegroups.com:

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

Privs acquired via ROLE (such as DBA role), do apply within PL/SQL procedures (such as DBMS_STATS). Received on Fri Sep 16 2005 - 08:30:46 CDT