Re: Grant SYS.x$KCCCP to DBA..........................

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 24 Aug 2004 21:31:49 +1000
Message-ID: <412b2722$0$14187$afc38c87@news.optusnet.com.au>

marjina98_at_hotmail.com wrote:

> Hi,
>
> How should we grant SYS.x$KCCCP to DBA?
> I am using following command to grant SYS.x$KCCCP to DBA but getting
> the following error:
>
> *
> ERROR at line 1:
> ORA-02030: can only select from fixed tables/views
>
> I am using version 8.1.7.0.
>
>
>
> Thanks
>
> Marjina

The real question is not "how", but "why".

What is in that table that you think someone needs constant access to? I can think of nothing but CPODR_BNO... and I can't imagine for one minute what possible use it could be to any DBA to know that information on a regular basis!

Regards
HJR Received on Tue Aug 24 2004 - 06:31:49 CDT