Settings on the Foreign Schema Instance

Settings on the FDO Schema Instance

Foreign Schema Settings

Oracle Identity Property

 

Settings on the Foreign Schema Instance

If the foreign schema is on a different Oracle instance, create an FDO user using the same Username and password as on the instance where the FDO schema exists.

Grant the select, update, delete, and insert privileges on tables (views, sequences) to the FDO user that is mapped to the FDO schema. Note that if the Foreign Schema tables are enabled for Oracle Workspace Manager, the privileges must be granted for the based table.