IFX_EXTEND_ROLE configuration parameter
Your database system administrator (DBSA), by default user informix, can use the IFX_EXTEND_ROLE parameter to control which users are authorized to register DataBlade® modules or external user-defined routines (UDRs).
- onconfig.std value
- IFX_EXTEND_ROLE 1
- values
1
orOn
(default) = Enables the requirement for the EXTEND role so that administrators can grant privileges to a user to create or drop a UDR that includes the EXTERNAL clause.0
orOff
= Disables the requirement for the EXTEND role, so that any user who holds the USAGE ON LANGUAGE privilege for the appropriate external language (C or JAVA) can register or drop an external routine that was written in that language.- takes effect
- After you edit your onconfig file and restart the database server.