How get full read-only access to schema?
I have a schema tst_cxldb1. I created a new user and logged in as the schema owner, gave that user the right to select any table. When I create a connection in SQL Developer, the user can do seelct statements against the tables in that schema. the problem is that I need the user when connected through SQL Developer to have the same stuff listed in the left menu (like tables, their definition and column definitions), but be limited to read only. Literally I want it to look identical to the way it is for the schema owner except that it is limited to read access. How do I do this?