RE: V$OBJECT_USAGE view for indexes in all schemas

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Tue, 18 May 2004 09:16:01 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93991@qtiexch2.qgraph.com>

Oracle Support has reproduced the error in 9.2.0.5 on other platforms:

GRANT SELECT ON sys.object_usage TO my_dba; ORA-00701: object necessary for warmstarting database cannot be altered

After that, ORA-600s galore. Joy.

I think we need to look at removing the 9.2.0.5 patch...

Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_quadtechworld.com      QuadTech, Sussex, WI USA

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> Sent: Monday, May 17, 2004 7:09 PM
> To: oracle-l_at_freelists.org
> Subject: RE: V$OBJECT_USAGE view for indexes in all schemas

>=20
>=20

> What do you mean by "SYS.OBJECT_USAGE table cannot be changed,
> apparently including GRANTs."
> Are you signing on as SYSDBA and issuing the command
> "GRANT SELECT ON OBJECT_USAGE TO MYUSER;" ? (you could also=20
> grant MYUSER
> the system privilege SELECT ANY DICTIONARY)
> That privilege should allow you to create your own copy of
> V$OBJECT_USAGE in schema MYUSER.

---

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 - 09:32:12 CDT