Re: accessing a view from another user

> | assume:
> |
> | user a has the table tab_a
> | user b has select-right on the table tab_a an creates the view view_b
> |
> | create view view_b as
> | select * from a.tab_a;
> |
> | this works fine and b can see the content of the table tab_a.
> |
> | now b grants user c the select-right on his view view_b.
> | but when c tries to look at the view
> |
> | select * from b.view_b
> |
> | he gets an ora-01031: insufficient privileges! why? this even happens
> | with select-rights on the table tab_a from user a! now he could create
> | an own view on the table of user a or look directly on this table, but
> | he still can't open the view of user b!
> |
> | what must be done that user c can look at the view view_b from user b?
> |
> | thanx
> |
> | matthias
>
> b has rights, but notthe privilege to pass them on (which is what granting
> on the view attempts to do)
>
> this requires the GRANTE xxxx ... WITH GRANT OPTION syntax
>
> ++ mcs

that's it! thank you! Received on Wed Sep 15 2004 - 16:45:42 CEST