EXTEND Role Required to Register a C UDR

For security reasons, only users who have been granted the EXTEND role can register external UDRs. The database system administrator (DBSA, user informix by default) specifies which users have this permission as determined by the setting for EXTEND role in the IFX_EXTEND_ROLE configuration parameter in the ONCONFIG file.

When a user creates or drops a procedure or a function, the database server checks if the statement has the EXTERNAL clause, and then it checks if the user has been granted the required permission. If the user does not have the EXTEND role, the statement will fail. The default setting for the IFX_EXTEND_ROLE configuration parameter is OFF. For more information about the IFX_EXTEND_ROLE configuration parameter, see the IBM Informix: Dynamic Server Administrator's Reference.