Privileges required for dbms

From: Jack Wang <nospam_at_nospam.com>
Date: Tue, 30 Dec 2003 05:55:57 GMT
Message-ID: <Nr8Ib.96007$ss5.72702@clgrps13>

Oracle 9203 on W2K with SP4

I wonder what are privileges required for dbms_stats.gather_schema_stats(ownname=>'someone else', cascade=>true)?

A user with the privileges of 'create session' and 'analyze any' was able to dbms_stats.gather_schema_stats(ownname=>'someone else'). What is required for the cascade=>true bit?

Given 'select any table' still produces

ERROR at line 1:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 9357
ORA-06512: at "SYS.DBMS_STATS", line 9839
ORA-06512: at "SYS.DBMS_STATS", line 10023
ORA-06512: at "SYS.DBMS_STATS", line 10077
ORA-06512: at "SYS.DBMS_STATS", line 10054
ORA-06512: at line 1

Any help is appreciated.

Jack

Received on Mon Dec 29 2003 - 23:55:57 CST

Privileges required for dbms_stats