I am trying to export the schema's objects by using Tools -- Database Export without selecting any of the data.
It generates no output.
Halfway in the process at step 3 of 5 i can select which objects to export, however this screen shows nothing while it normally should list the objects.
I think it has to do with wich (system)tables the user from the connection needs to access in order to populate this list.
Can somebody tell me what tables/views the connection needs ?
To export a table you need to own the table or have select on the table. Also, if you do not own the table you should have select_catalog_role. If you do not have select on the table or own the table, you will not be able to the find the object using the Specify Objects step of the wizard. If you can find the object, you still may not be able to export it unless you own the object or have select_catalog_role.
On the Specify Objects panel, you must click on Lookup to get the list of objects. If you are trying to export objects in another schema, you have to click on More, select the schema and then click lookup.
Still have problems, please describe exactly what you are doing and clicking in the wizard. Indicate what privieleges you have. Also try to find the object using view-> Find DB Object and report what you did and the results.