Table/View permissions
I have a dilemma. I have been setup with a limited database account to query an oracle 11 database, it is actually the backend database behind the oracle e-business suite product. I keep finding tables/views I need to query but when I query them i.e. Select * from table it returns 0 results.
However, I have proven that sometimes they return no results as the limited account I have has limited permissions, so it isnt returning 0 results as their is no data in the table/view, its because my account cannot query it due to permissions. Then if we run the same query with an account like APPS it returns results.
Is there query to list all tables/views that my database account can query. And what account is required to run such a query, i.e. APPS etc
Or, if I use the table/view as a parameter, if there any query I can run to say for table/view A, these accounts have these permissions on the table to view the data?
Thanks