Informix users

Posted in 2025

Summary

Eduardo Rodriguez, running Informix 14.10 on AlmaLinux 9.6 with about 70 users, asked how to audit connections and actions and whether all users need OS accounts. David Williams advised onaudit and roles, and said OS users are needed. Sebastien Flaesch suggested internally authenticated users via CREATE USER. Doug Lawry pointed to a connection logging FAQ.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Security, Permissions & Auditing

Eduardo Rodriguez — source: IBM Community (ConnectedCommunity.org) Informix forum

Hello everyone, I'm currently managing an Informix 14.10 database running on AlmaLinux 9.6, and I have around 70 active users. I'd like to know what best practices or recommended tools are for better control and management of these users. Some of my specific questions are: How can I audit or monitor which users are connecting and what actions they perform? Do I have to create all 70 users on my system? Thank you in advance! ------------------------------ Eduardo Rodriguez ------------------------------

↪ replying to Eduardo Rodriguez

David Williams — source: IBM Community (ConnectedCommunity.org) Informix forum

Hi, How can I audit or monitor which users are connecting and what actions they perform? Using onaudit - check the manual. Do I have to create all 70 users on my system? Yes, other you can not define the permissons they have. However look up roles and default role. Regards, David. ------------------------------ David Williams Senior Database Platform Engineer Flutter London ------------------------------

↪ replying to Eduardo Rodriguez

Sebastien FLAESCH — source: IBM Community (ConnectedCommunity.org) Informix forum

Hi Eduardo, I don't know well Informix auditing features. However, you could create "internal authenticated users", to avoid to create 70 system users: https://www.ibm.com/docs/en/informix-servers/14.10.0?topic=statements-create-user-statement-unix-linux I assume (I hope!) Informix auditing features also applies to internal authenticated users. How does your application connect to the server? In what programming language? Seb ------------------------------ Sebastien FLAESCH ------------------------------

↪ replying to Eduardo Rodriguez

Doug Lawry — source: IBM Community (ConnectedCommunity.org) Informix forum

See also: https://www.oninitgroup.com/faq-items/informix-connection-logging ------------------------------ Doug Lawry Oninit Consulting ------------------------------