EXTEND role required to register a C UDR
For security reasons, when the IFX_EXTEND_ROLE configuration
parameter is set to 1
or to On
,
only users who have been granted the EXTEND role by the database server
administrator (DBSA) can register external UDRs.
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 fails. The default
setting for the IFX_EXTEND_ROLE configuration parameter is On
.
For more information about the IFX_EXTEND_ROLE configuration parameter,
see the Informix® Administrator's
Reference.