We have created a new oracle database and created many tables trying to access it from developer using JDBC adapter.
We don’t want to use any schema in the queries, just the table name. so that Even if we promote to different environment it should work.
So we made those tables visible under currentShema and granted SELECT privileges on the tables directly to user.
But still we are not able to see fields of those tables.
Even we granted below permissions, its of vain?
GRANT CREATE SESSION
GRANT CREATE VIEW
GRANT GLOBAL QUERY REWRITE
GRANT SELECT ANY DICTIONARY
GRANT UNLIMITED TABLESPACE
But still we are not able to resolve the issue. Kindly help us in getting this resolved.
Thanks in advcance!!!