Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!k70g2000cwa.googlegroups.com!not-for-mail
From: "Anurag Varma" <avoracle@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: gather_system_stats problem on 10.2
Date: 10 Oct 2006 09:07:21 -0700
Organization: http://groups.google.com
Lines: 49
Message-ID: <1160496441.051311.92310@k70g2000cwa.googlegroups.com>
References: <ChyWg.17555$wE5.4319@trnddc02>
   <452ab53a$0$24412$ba620e4c@news.skynet.be>
   <GIyWg.17643$wE5.11425@trnddc02>
   <452B9923.E7B@yahoo.com>
NNTP-Posting-Host: 13.13.137.2
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1160496446 26697 127.0.0.1 (10 Oct 2006 16:07:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 10 Oct 2006 16:07:26 +0000 (UTC)
In-Reply-To: <452B9923.E7B@yahoo.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.7) Gecko/20060909 Firefox/1.5.0.7,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: k70g2000cwa.googlegroups.com; posting-host=13.13.137.2;
   posting-account=Bjij0w0AAACWMZ9jVkCMjBKLT0Yf1PAH
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:276943


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@yahoo.com
>
>
> "Semper in excremento, sole profundum qui variat."
>
> ------------------------------------------------------------

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

Anurag