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

Thanks,

Is creating a view on fixed tables is the only solution for my query? Should the view which we created for the fixed table SYS.x$KCCCP refresh implicitly?
By default, is there an alternative view of this fixed table SYS.x$KCCCP available, if so what is that view.

you are right I want to see the column CPODR_BNO on regular basis in order to findout how much amount of redo generated in the current log file.

Thanks

Marjina

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<412b2722$0$14187$afc38c87_at_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 Wed Aug 25 2004 - 03:15:03 CDT