External routines

This release of does not support language-level privileges on external routines that are written in the C or Java™ language. When the IFX_EXTEND_ROLE configuration parameter to ON, however, equivalent functionality is provided through the built-in EXTEND role, which is required for any user to register, drop, or replace a UDR or a DataBlade® module that is written in the C or Java language.

Only the database server administrator (DBSA), by default user informix, can grant the EXTEND role. In contrast with user-defined role names, built-in roles such as EXTEND and DBSECADM are automatically active, and the privileges conferred by the role cannot be modified. When the EXTEND role is enabled, only users who have been granted the EXTEND role can create or drop a DataBlade module or an external UDR.

The DBSA also has the option of disabling this restriction by setting the IFX_EXTEND_ROLE configuration parameter to OFF, or to leave it unset. In this case, any user who holds the RESOURCE privilege on the database can create a UDR written in the C or Java language.