Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Informix users

    Posted 06/06/25 02:54 PM
    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
    ------------------------------


  • 2.  RE: Informix users

    Posted 06/09/25 06:20 PM

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



  • 3.  RE: Informix users

    Posted 06/10/25 02:16 AM

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



  • 4.  RE: Informix users

    Posted 06/10/25 06:58 AM

    See also:

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



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



Related Content