Hi Pengshan, the table you are querying from the ThingWorx Composer, does that exist in the Scott schema or outside the Scott's schema? Are you able to query this particular table using exactly the same username/password you are using to connect the Database thing?
Since if you can see the table there in the database then this error may point to the access rights for the user account.
Hi Sushant, the table that I'm querying from the ThingWorx Composer really exist in the Scott schema. I can query this particular table using exactly the same username/password which is using to connect the Database thing.
How should I set the access rights in the Oracle Database then these tables can be accessed in the ThingWorx Composer?
Thank you for your help!
You can do following to check whether or not your access permissions is set correctly
1. Login with the same user ,with which you have setup the connection in ThingWorx Composer, SQL*Plus or SQL Developer
2. Check if you are able to perform CRUD on that table
3. If you are not able to perform CRUD operations on that table you'll need to grant this user enough access rights