Re: How do you grant select on x$ table to system?

Joe,

The x$ tables could be queried only by SYS. Therefore you can not even create a public synonym for those tables and grant select on it. But you can always create a view, then grant select on this view to any user:

SQL>connect sys/<secret>@<service_name>

SQL>CREATE VIEW v_x$bh AS SELECT * FROM x$bh; SQL>GRANT SELECT ON v_x$bh TO system;

Then system can now select from x$bh table.

Check the latest Oracle DBA forums for more gotchas: http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message news:l.1020789037.1096618652@[64.94.198.252]...
> I tried
>
> SQL> grant select on x$bh to system;
> grant select on x$bh to system
> *
> ERROR at line 1:
> ORA-02030: can only select from fixed tables/views
>
> Could somebody tell me what is the correct way to do this?
>
> Thanks
>
>
>
>
>
> --
> Sent by joebayerii from hotmail in field com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Tue May 07 2002 - 18:11:52 CDT