Here at work, when I need to connect to the Oracle database, I have to login using a public username, then set the role I want, so I can view the tables I need.
The problem is when I need to configure a datasource for my EJB module, using JBuilder. Since I need to connect to Oracle using a public username, JBuilder only displays the tables from the public schema. Is there a way I can set the correct role, so I can view the correct tables?
Enabling the options "All schemas" will work, but since there are thousands and thousands of tables, I prefer not to do that. It takes a long time to load'em all.
Thanks in advance.