470,821 Members | 2,084 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,821 developers. It's quick & easy.

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
Jul 19 '05 #1
2 7428

"matthias" <wi********@gmx.de> wrote in message
news:aa**************************@posting.google.c om...
| 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
Jul 19 '05 #2
> | 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!
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Russell Read [MSFT] | last post: by
2 posts views Thread by le0 | last post: by
2 posts views Thread by matthias | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.