Oracle Identity Property
FDO Provider for Oracle and Foreign Schemas
Foreign Schema Limitations
Read-Write Privileges
If FDO requires read-write privileges to work with a foreign schema, the owner of the foreign schema must grant these privileges. Also, access to the Oracle metaschema on the tables is required.
NoteThe owner must explicitly
grant these privileges. These privileges will vary, according to
the schema owner.