------------------------------
Eduardo Rodriguez
------------------------------

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
------------------------------

Original Message:
Sent: Fri June 06, 2025 02:53 PM
From: Eduardo Rodriguez
Subject: Informix users

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
------------------------------

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
------------------------------

Original Message:
Sent: Fri June 06, 2025 02:53 PM
From: Eduardo Rodriguez
Subject: Informix users

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
------------------------------

See also:

https://www.oninitgroup.com/faq-items/informix-connection-logging

------------------------------
Doug Lawry
Oninit Consulting
------------------------------

Original Message:
Sent: Fri June 06, 2025 02:53 PM
From: Eduardo Rodriguez
Subject: Informix users

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
------------------------------