Re: gather_system_stats problem on 10.2

From: Anurag Varma <avoracle_at_gmail.com>
Date: 10 Oct 2006 09:07:21 -0700
Message-ID: <1160496441.051311.92310@k70g2000cwa.googlegroups.com>

Connor McDonald wrote:
> Chuck wrote:
> >

-SNIP-
> > It already has ANALYZE ANY. Here's all the sys privs the user already has.
> >
> > SQL> SELECT PRIVILEGE FROM user_sys_privs
> >
> > PRIVILEGE
> > - ----------------------------------------
> > CREATE SESSION
> > SELECT ANY TABLE
> > EXECUTE ANY PROCEDURE
> > ANALYZE ANY
> > SELECT ANY DICTIONARY
> > UNLIMITED TABLESPACE
> > EXEMPT ACCESS POLICY
> >
> > 7 rows selected.
> >
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.5 (MingW32)
> >
> > iEYEARECAAYFAkUqt6UACgkQzIf+rZpn0oQ4WACghqv1OZp4wGu1JZXpvhf15Pr9
> > +5wAnjxLarZvjadVahPhwIV1aGiVAIWf
> > =jTGA
> > -----END PGP SIGNATURE-----

>

> There is a role/priv specifically for system stats - can't remember its
> name off hand, but you'll need it, or you'll need to run as sysdba
> --
> Connor McDonald
> Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
> Co-author: "Oracle Insight - Tales of the OakTable"

>

> web: http://www.oracledba.co.uk
> web: http://www.oaktable.net
> email: connor_mcdonald_at_yahoo.com

>
>

> "Semper in excremento, sole profundum qui variat."
>
> ------------------------------------------------------------

Maybe its the "analyze any dictionary" priv. Try granting that....

Anurag Received on Tue Oct 10 2006 - 11:07:21 CDT