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

Thread: Grant on sys.x$bh

  1. #1
    Join Date
    Jul 2001
    Posts
    108

    Question Grant on sys.x$bh

    Hello,

    How can I assign the SELECT permission on sys.x$bh table to SYSTEM users?

    Thanks,
    Nikee

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    SQL> create view x_$bh as select * from x$bh;

    View created.

    SQL> grant select on x_$bh to scott;

    Grant succeeded.

    SQL> create public synonym x$bh for sys.x_$bh;

    Synonym created.

    SQL> conn scott
    Enter password:
    Connected.
    SQL> select count(*) from x$bh;

    COUNT(*)
    ----------
    3006


    SQL> desc x$bh
    Name Null? Type
    ----------------------------------------- -------- ---------------------

    ADDR RAW(4)
    INDX NUMBER
    INST_ID NUMBER
    HLADDR RAW(4)
    BLSIZ NUMBER
    NXT_HASH RAW(4)
    PRV_HASH RAW(4)
    NXT_REPL RAW(4)
    PRV_REPL RAW(4)
    FLAG NUMBER
    RFLAG NUMBER
    SFLAG NUMBER
    LRU_FLAG NUMBER
    TS# NUMBER
    FILE# NUMBER
    DBARFIL NUMBER
    DBABLK NUMBER
    CLASS NUMBER
    STATE NUMBER
    MODE_HELD NUMBER
    CHANGES NUMBER
    CSTATE NUMBER
    LE_ADDR RAW(4)
    DIRTY_QUEUE NUMBER
    SET_DS RAW(4)
    OBJ NUMBER
    BA RAW(4)
    CR_SCN_BAS NUMBER
    CR_SCN_WRP NUMBER
    CR_XID_USN NUMBER
    CR_XID_SLT NUMBER
    CR_XID_SQN NUMBER
    CR_UBA_FIL NUMBER
    CR_UBA_BLK NUMBER
    CR_UBA_SEQ NUMBER
    CR_UBA_REC NUMBER
    CR_SFL NUMBER
    CR_CLS_BAS NUMBER
    CR_CLS_WRP NUMBER
    LRBA_SEQ NUMBER
    LRBA_BNO NUMBER
    HSCN_BAS NUMBER
    HSCN_WRP NUMBER
    HSUB_SCN NUMBER
    US_NXT RAW(4)
    US_PRV RAW(4)
    WA_NXT RAW(4)
    WA_PRV RAW(4)
    TCH NUMBER
    TIM NUMBER

  3. #3
    Join Date
    Jul 2001
    Posts
    108
    Hello Axr2,

    Thank you very much.

    Best regards,
    Nikee

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