DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

  1. #1
    Join Date
    Aug 2004
    Posts
    11

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

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    try x_$..

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Looks like you are trying to grant access on that fixed table other than SELECT?

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

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

    Originally posted by marjina98
    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
    fixed tables are solely owned by sys/internal and it should not be touch other than select, that is why views are created like DBA_* and V$* for.

  5. #5
    Join Date
    Jul 2000
    Posts
    296
    You cannot grant a select privilige on a x$ table. Create a view on the x$ table and grant select privilege on the view.

    SQL> grant select on SYS.x$KCCCP to dba;
    grant select on SYS.x$KCCCP to dba
    *
    ERROR at line 1:
    ORA-02030: can only select from fixed tables/views


    SQL> create view sys.my$kcccp
    2 as
    3 select * from x$kcccp;

    View created.

    SQL> grant select on sys.my$kcccp to dba;

    Grant succeeded.

    SQL> conn system/manager@mydb
    Connected.
    SQL> select * from sys.my$kcccp;

  6. #6
    Join Date
    Aug 2004
    Posts
    11
    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.

    Thanks

    Marjina

  7. #7
    Join Date
    Aug 2004
    Posts
    11
    Hi,

    I am looking forward to hearing from someone to give me the answer of my last post.

    Regards

    MArjina

  8. #8
    Join Date
    May 2001
    Posts
    736
    I don't think that u have an explicit view.Follow as explained by the other member.

  9. #9
    Join Date
    Jul 2004
    Location
    bangalore
    Posts
    24
    x$kcccp means kernel cache checkpoint progress. None of the v$/gv$ views exposes these table columns. You can not grant x$ table directly. This is a restriction with x$ table.

    Thanks and Regards,
    Satheesh Babu.S

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width