cant query view but have table privileges (not found in ALL_VIEWS)
DirdApr 2 2012 — edited Apr 2 2012Hi guys,
I have a strange (to me~) problem where I have a view querying 4 tables. the creator and another user can call the view but a third user cannot.
If I query ALL_OBJECTS or ALL_VIEWS with this user the view is not listed. However, the user has privileges to all tables used. This has been verified by running the except same query associated with the view & the it returned the results as expected~
When I try to call the view it says it doesn't exist though. With the other users I can call either the view or the underlying query. Any idea what privilege may be missing that means the user cant call a view?
Mike