ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Is it possible to set up ORDS to login as different users?
Now, the ORDS installation is associated with one schema user. Hence, when a REST service calls a package the value of the USER keyword would be the same all the time. The underlying application we are using, uses the USER keyword to tag rows that are edited. Hence, it would be nice if ORDS could use several schemas to login with. In that way, we have more control and can see if a row has been created or updated from a REST service.