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