Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> grant select on x$ table

grant select on x$ table

From: Steve Robin <ocmaman_at_gmail.com>
Date: 28 Jan 2007 21:45:35 -0800
Message-ID: <1170049535.873373.325490@s48g2000cws.googlegroups.com>


please let me know how to give select priviledge on x$ tables. I am try to give select on x$ktfbhc view to one of user. But I am getting error :

SQL> grant select on x$ktfbhc to dbcheck; grant select on x$ktfbhc to dbcheck

                *

ERROR at line 1:
ORA-02030: can only select from fixed tables/views Received on Sun Jan 28 2007 - 23:45:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US