Re: V$OBJECT_USAGE view for indexes in all schemas

  • From: Boris Dali <boris_dali@xxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 18 May 2004 08:50:07 -0400 (EDT)

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@xxxxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: