I don't know about x$bh. For others (from 9i and beyond) (from SYS):

grant select on xxxxx to your_view_owner WITH GRANT OPTION;

There is a group of objects in sys schema that can not be granted like that.
My way around:

create view my_xxxxx as select * from xxxxx;
create synonym your_view_owner.my_xxxxx for my_xxxxx;
grant select on my_xxxxx to your_view_owner with grant option;

modify refference from "xxxxx" to "my_xxxxx" in your views

KAzi

Igor Stanishevskiy wrote:
> Hi, junior and senior DBA's.
>
>
>
> I have the next problem. I've migrate a database from 8 to 10 version.
>
> But I've noticed that a part of users' objects are invalid. I tried to
> recompile them.
>
> But it didn't help. A part of this objects are view which are referring
> to system views such as x$bh, v$instance.
>
> I granted a select any dictionary to those users. It helped to recompile
> a part of objects, but another part of objects rested.
>
> I don't know what to do, how to recompile them. The public synonym x$bh
> exists.
>
>
>
> Any help will greatly appreciated.
>
>
>
> Thanks in advance.
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>


Oracle LazyDBA home page