view privilege

view privilege

 

  

user1 created a view and grant all base tables' select privilege to user2

user2 can not select from the view. the error is the table or view not exists.

What kind of privilege does user2 need in order to see user1's view?

Thanks.l


Oracle LazyDBA home page