You can override the owner name or table name for the source table in a lookup view. You may need to override the owner name if the table exists in a different schema. You may need to override the table name if the table name changes or you want to use a different table that has the same table metadata.
To perform the override, enter the new owner name, table name, or both in the Override Owner Name connection property for the source table. When you enter the new owner name or table name, you must use a valid syntax.
You must have Execute permission on the owner name to override the owner name.
The following table specifies the required syntax for each type of override: