I have installed the SQL Explorer plugin for Eclipse. I have the connection working OK but if I connect with a read only ID, I can only view a list of the database tables. The functions and procedure elements of the database structure view will not populate with the functions/procedures in the schema.
If I connect with an ID that has update permissions to the database, the function and procedure elements of the database structure view populate correctly.
I am connecting to an Oracle database (10.2.0.4.0) using the Oracle thin driver from oracle.jdbc.OracleDriver in ojdb6.jar. I am using version 3.5.2 of the Eclipse platform on a WinXP machine.
Incedentally, I tried to install the Toad plugin for Eclipse and have the exact same issue.
Can anyone please suggest a solution? I need to be able to use the read only ID in order to access or view database tables, procedures and functions in a production environment.