Informix Security Review: Extensibility: UDRs, SPL and Hooks
Checks EXT-01 onwards: code the server will run.
Code that runs inside the server runs as informix. A C UDR or an SPL SYSTEM call is a path from SQL to an OS shell, so this is where a database-level foothold becomes a host compromise.
| ID | Check | Default severity | Script source |
|---|---|---|---|
| EXT-01 | Inventory of external routines (C, Java) with their shared-object paths; any path outside DB_LIBRARY_PATH or user-writable | High if writable, else Info | sysprocedures.externalname, sysroutinelangs + file perms |
Remediation: Move libraries under $INFORMIXDIR/extend or a root-owned dir | |||
| EXT-02 | USAGE ON LANGUAGE C or JAVA granted to PUBLIC or to non-administrators | High | syslangauth |
| Remediation: Revoke; keep IFX_EXTEND_ROLE on and grant EXTEND to named users | |||
| EXT-03 | SPL routines that call SYSTEM | High if PUBLIC can execute, else Medium | sysprocbody text search |
| Remediation: Remove, or restrict EXECUTE and validate every argument | |||
| EXT-04 | DBA-mode procedures (sysprocedures.mode = 'D') executable by PUBLIC | High | sysprocedures, sysprocauth |
| Remediation: Revoke EXECUTE FROM PUBLIC | |||
| EXT-05 | sysdbopen / sysdbclose procedures exist; content reviewed | Medium | sysprocedures + body dump |
| Remediation: Confirm they cannot be bypassed or abused | |||
| EXT-06 | Routines granted EXECUTE to PUBLIC in system databases beyond the defaults | Medium | sysprocauth |
| Remediation: Revoke | |||
| EXT-07 | Holders of the EXTEND role | Info | sysroleauth (rolename extend) |
| Remediation: Limit to UDR developers / DBSA | |||
Part of the Informix Security Review set. Check IDs are the ones used in the findings file of the scripts.