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.
NoteThis FDO user does not
need to have been granted the f_user_role role.
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.