A file import running through a custom method invoked via IFS Connect (routing rules/address, initiated as the IFSCONNECT user) fails with 'PLS-00904: insufficient privilege to access object IFSAPP.<custom_package>' — how is this fixed?

Q: A file import running through a custom method invoked via IFS Connect (routing rules/address, initiated as the IFSCONNECT user) fails with 'PLS-00904: insufficient privilege to access object IFSAPP. ' — how is this fixed?

Grant EXECUTE on the custom package explicitly to IFSSYS: GRANT EXECUTE ON IFSAPP. TO IFSSYS;. Standard IFS packages already carry the grants IFSSYS needs (SELECT on views, EXECUTE on methods, and SELECT/UPDATE/INSERT on tables with LOB columns), but a custom package doesn't get that automatically — it has to be granted manually. If the error persists after granting to IFSSYS, also grant EXECUTE on the same package to IFSCONNECT, since that's the user the process is actually running as in this integration flow.

Answer

Grant EXECUTE on the custom package explicitly to IFSSYS: GRANT EXECUTE ON IFSAPP.<custom_package> TO IFSSYS;. Standard IFS packages already carry the grants IFSSYS needs (SELECT on views, EXECUTE on methods, and SELECT/UPDATE/INSERT on tables with LOB columns), but a custom package doesn't get that automatically — it has to be granted manually. If the error persists after granting to IFSSYS, also grant EXECUTE on the same package to IFSCONNECT, since that's the user the process is actually running as in this integration flow.

← Browse Integrations and APIs questions