Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table/View permissions

user599292Jan 17 2011 — edited Jan 17 2011
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
This post has been answered by Murali Mohan on Jan 17 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 14 2011
Added on Jan 17 2011
16 comments
89,564 views