I'm trying to set up ORDS on the local JDE database, to get REST access to some of the interoperability tables. I've been able to get through the ORDS setup and install with SQLDeveloper 17.2 and the embedded ORDS 3.0.11. I created an ORDS user/schema and enabled rest services on it. I was able to enable rest services for a table directly under that user, but when I try to enable for the interoperability table under user JDEDATA920, I get this error in the wizard:
Invalid members: executeOracleQuery failed: SELECT * FROM TABLE(ORDS_METADATA.ORDS.check_object_support(p_schema=>'JDEDATA920', p_object=>'F0101Z2', p_object_type=>'TABLE'))
How can I enable REST for a table under a different user? I don't know the user password for the JDEDATA920 table, because it was set up by JDE and is most likely encrypted anyway. Nor can I reset it without breaking JDE. But I can grant access to that table to the ORDS user, so I was hoping I could set up rest accessing that table as the ords user.