This content has been marked as final. Show 5 replies
Are you connecting to any oracle applications database like e-busniess suite?
No....just garden vaillna database
There have been bugs in the past regarding not being able to see objects, or object details, in the Object Viewer and Schema Browser for which you have privileges. For example:
Re: Viewing Tables/Schema
Not seeing query results in the Worksheet, however, means you do not own the object or have select privilege on it. If you are not the owner and have no specific object grants, then having the SELECT_CATALOG_ROLE role or SELECT ANY DICTIONARY system privilege permits viewing of the metadata only.
Are you absolutely certain you are the owner or otherwise have select privileges? Perhaps you trying to run a query against a table you can see but do not own under the Other Users node in the connections navigator tree?
You might also try upgrading to 3.2.2, but it sounds more like a privilege issue to me.
SQL Developer Team
I also thought about priveleges as that what it seems so I tried giving DBA privs and it still did not give me any output.
Another option: there are "policies" defined for this table.
"Policies" determine for each record of table if it is visible or not visible to certain user.
You can check if there are any "policies" in the following way:
View -> Reports -> Data Dictionary Reports -> Security -> Policies -> Policies