Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help: select on x$kcbfwait
one of our script needs to select against x$kcbfwait as system. Some
of our database is OK to run it, some of the database can not select
against x$kcbfwait as system.
When I issue "grant select on x$kcbfwait to system" as sys,
I got
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
Why some other databases can let system to select? How can I grant select on x$kcbfwait to system?
Thanks
-- Sent by dbadba62 from hotmail part from com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/content/newReceived on Tue Feb 19 2002 - 16:07:09 CST