Permission to gather_table_stats

[marist89]

Originally posted by Mr.Hanky
You may want to try and drop the "cascade=>TRUE" parameter since it is used for the corresponding index and the errors seem to point to that as the problem.

MH

Plus, it works as the owner...

SQL> connect a/a
Connected.
SQL> exec dbms_stats.gather_table_stats(ownname=>'A',tabname=>'XYZ',partname=>'P2',cascade=>TRUE);

It's got to be permissions, right?