I have credentials to connect to an Oracle instance where my ID has permissions to several user schemas. When I connect in the form designer I can see table names from one of the schemas, but the other, which contains views and stored procedures I need to use is not visible. Is there something in the connection properties that might cause this? Initially, as I was adding reference data to populate pick lists, I would select the underlying table from the schema I can see, then in the controller action I would change the SQL to use the correct view entity(for example: change the generated "SELECT * FROM STATE_REF;" to "SELECT * FROM DAL.STATE_REF_VW;". This works fine, but as I move on to connecting the main form data, I need to see the views that have been created so I can get the tree structure I need to perform my many bindings...
RE: Cannot see view objects on Oracle connection
Could you clarify exactly what sort of heirarchy you have in detail including details of the groupings by permissions.
When you do see tables from one schema, is this the first one available?
Do you see different tables and views structures if different credentials are used?
RE: Cannot see view objects on Oracle connection
(As an aside, when I first received these credentials I had access to another user DB with identical tables to AFMSS2. While Webmaker only showed each tablename once in the pick list, the field list was duplicated in the tree strucure once I selected a table. I had the DBA remove me from the second DB. Just thought I'd mention...)
RE: Cannot see view objects on Oracle connection
So, in your case it is showing the AFMSS2 user DB only.
To be able to select all the tables required it would be necessary to have two different users defined against the database, one viewing the AFMSS2 and the other viewing DAL tables?
You can then use the Studio to select the appropriate tables and drag on the fields to setup the data bindings for each table.
This will create two database connections, one fo each user.
You could leave it with the two different DB user connections used in the application.
If required for performance and optimization, you could go to the rules for one of the SQL rules and change the DB connection details to use just the one DB connection.
However, if you delete the other unused db connection, this would impact the ability to pull on more fields from the second user db connection.
RE: Cannot see view objects on Oracle connection