Re: grant select on x$ table

Steve Robin schrieb:
> please let me know how to give select priviledge on x$ tables. I am
> try to give select on x$ktfbhc view to one of user. But I am getting
> error :
>
> SQL> grant select on x$ktfbhc to dbcheck;
> grant select on x$ktfbhc to dbcheck
> *
> ERROR at line 1:
> ORA-02030: can only select from fixed tables/views
>

You may be interested to have a look in Steve Adams Book http://www.amazon.com/Oracle8i-Internal-Services-Latches-Memory/dp/156592598X/sr=8-1/qid=1170059956/ref=pd_bbs_1/103-9903654-6119853?ie=UTF8&s=books or read here
http://examples.oreilly.com/orinternals/readme.html for a workaround.

Best regards

Maxim Received on Mon Jan 29 2007 - 02:37:39 CST