accessing a view from another user
From: matthias <wild.utzel_at_gmx.de>
Date: 15 Sep 2004 00:39:13 -0700
Message-ID: <aae2699f.0409142339.3cb2f9ea_at_posting.google.com>
assume:
Date: 15 Sep 2004 00:39:13 -0700
Message-ID: <aae2699f.0409142339.3cb2f9ea_at_posting.google.com>
assume:
user a has the table tab_a
create view view_b as
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
user b has select-right on the table tab_a an creates the view view_b
select * from a.tab_a;
matthias Received on Wed Sep 15 2004 - 09:39:13 CEST