Hi Team,
I have two database schema under the database. Schema User A is the user under which all the objects are created and the Schema User B has all the grants to access these objects and can perform CRUD operations.
When I am opening the SQL Work Sheet to run the below API to expose my object which is created under Schema A under the schema under B it does not work.
Having said that i able to make a select * from table. I can query the record easily in the same window
Is it possible to expose table from a a different schema under a different one ?
I know we can create ords for multiple database but what about multiple schema can we mapp it ?