Re: V$OBJECT_USAGE view for indexes in all schemas

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: Tue, 18 May 2004 08:50:07 -0400 (EDT)
Message-ID: <20040518125007.83507.qmail@web41413.mail.yahoo.com>

Worked just fine for us before 9.2.0.5

In 9.2.0.5 "grant select on sys.object_usage to ... " for the first time raises ORA-701 and subsequent grants throw ORA-600 [17058]

Support opened bug 3627650 for us, which apparently (as in not confirmed yet) can be fixed with the one-off patch for bug 2934068

Thanks,
Boris Dali.

• "Jesse, Rich" <Rich.Jesse_at_quadtechworld.com> wrote: > Hey all, ....
  > So, I create my own view <BZZZZT!>. I can't because
  > the SYS.OBJECT_USAGE table cannot be changed,
  > apparently including GRANTs.
  > I'd paste the error here, but when I try it again, I
  > get an ORA-600. =
  

  ---

Post your free ad now! http://personals.yahoo.ca

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 18 2004 - 07:56:23 CDT