Informix Security Review: Privileges, Roles and PUBLIC
Checks PRIV-01 onwards: what every database grants.
Run against every database in sysmaster:sysdatabases, plus sysadmin, sysuser and sysutils. PUBLIC grants are the most common real finding in older estates, because non-ANSI databases default to ALL for PUBLIC on new tables.
| ID | Check | Default severity | Script source |
|---|---|---|---|
| PRIV-01 | PUBLIC holds DBA or RESOURCE on a database | High (DBA: Critical) | sysusers usertype for public |
Remediation: REVOKE DBA/RESOURCE FROM PUBLIC; grant CONNECT only | |||
| PRIV-02 | Count and list of DBA users per database | Info (Medium if > 3 or includes app accounts) | sysusers usertype D |
| Remediation: Reduce to named administrators | |||
| PRIV-03 | PUBLIC holds INSERT/UPDATE/DELETE/ALTER/INDEX on user tables (tabid >= 100) | High | systabauth |
| Remediation: Revoke; grant to roles | |||
| PRIV-04 | PUBLIC holds SELECT on user tables | Medium (High if regulated data) | systabauth, syscolauth |
| Remediation: Revoke; grant to roles | |||
| PRIV-05 | Privileges WITH GRANT OPTION (upper-case flags) held by non-owners | Medium | systabauth, syscolauth, sysprocauth |
| Remediation: Re-grant without GRANT OPTION | |||
| PRIV-06 | Non-informix users with access to sysadmin (task/admin API) | High | sysadmin:sysusers |
| Remediation: Revoke; use GRANT ADMIN with specific privileges | |||
| PRIV-07 | Role inventory: roles, members, default roles, roles granted to PUBLIC | Info | sysroleauth, sysusers usertype G |
| Remediation: Remove unused roles | |||
| PRIV-08 | Unlogged databases (no forensic trail, no rollback) | Low | sysdatabases.is_logging |
| Remediation: Enable logging where data matters | |||
| PRIV-09 | LBAC policies and exemptions reviewed where LBAC is used | Medium | syssecpolicies, syssecpolicyexemptions (11.50+) |
| Remediation: Remove stale exemptions | |||
Privilege flags in systabauth.tabauth read positionally: s, u, *, i, d, x, a, r (select, update, column-level marker, insert, delete, index, alter, references). Upper case means WITH GRANT OPTION.
Part of the Informix Security Review set. Check IDs are the ones used in the findings file of the scripts.