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

• Post for FREE via your newsreader at post.usenet.com ****

Hi Marjina

You can create a view over the X$ table and grant select privilege on it.

Chris

<marjina98_at_hotmail.com> wrote in message news:24bfee06.0408240148.41344865_at_posting.google.com...
> 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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=