Yes, but it turned out to be privs (or lack thereof) to run the stats or associated queries in a procedure, rather than privs to do the analyze itself. Do you have auditing turned on? That's usually the first place I check to see what objects changed since the last time it worked.
GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 10:39 AM > To: Multiple recipients of list ORACLE-L > Subject: strange error on DBMS_STATS > > > I'm running dbms_stats.gather_schema_stats, the account running it is > NOT the schema owner, but DOES have the "analyze any" > privilege and has > read/write access to all the tables in the schema. We are not > trying to > gather stats into our own tables, just want the stats refreshed after > the (massive) loads into the DW tables. > > This has been running fine, then all of a sudden last night we started > getting ORA-1031 ("insufficient privileges") errors. Now, according to > the docs: > > ORA-01031 insufficient privileges > > Cause: An attempt was made to change the current username or > password without the appropriate privilege. This error also occurs if > attempting to install a database without the necessary > operating system > privileges. > > > We are not changing passwords, so I am presuming that this involves > (somehow) a change of username. According to the package header, it > will throw an ORA-20000 if there are insufficent privileges. > We rebuilt > an index yesterday but did NOT change or add any table. > > I had this happen once before, on a different database, never solved > it, but substituted dbms_utility.analyze_schema which worked. I can do > the same thing this time but I'd prefer to solve it. > > Anyone ever see anything like this before? > > oh yeah 9.2.0.1 on Solaris 8 > > Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
