Informix

 View Only

  • 1.  Granting Default Role in InformixHQ

    Posted Thu March 23, 2023 05:43 PM

    I am playing with the new(ish) InformixHQ to determine if it can take the place of the older AGS management software.   I have found one mission critical process for us that I don't see anywhere that InformixHQ can do....grant default database roles.

    I can create database privileges, and on that page, it shows default role, but I don't see anywhere to set this value in the website.   Am I missing it or does this product not do this (yet?)



    ------------------------------
    Jared Heath
    ------------------------------


  • 2.  RE: Granting Default Role in InformixHQ

    Posted Fri March 24, 2023 05:28 AM
    Hi Jared.

    That does seem to be missing.

    Our view is that HQ is very useful alongside AGS but does not replace it.

    This e-mail (and any files or other attachments transmitted with it) is intended solely for the attention of the addressee(s). Unauthorised use, disclosure, storage, copying or distribution of any part of this e-mail is not permitted. If you are not the intended recipient please destroy the email, remove any copies from your system and inform the sender immediately by return. Oninit Consulting Ltd does not accept any liability or responsibility for any damage caused by any virus transmitted by this email or for changes made to this e-mail after it was sent. All communications to or from Oninit Consulting Ltd may be automatically logged, monitored and/or recorded in order to secure the effective operation of the system and for other lawful purposes. The views or opinions contained within this e-mail may not necessarily reflect those of Oninit Consulting Ltd.



    Original Message


  • 3.  RE: Granting Default Role in InformixHQ

    Posted Fri March 24, 2023 12:08 PM

    It definitely needs some maturity.   Especially in the space/chunk presentation, which is really poor



    ------------------------------
    Jared Heath
    ------------------------------

    Original Message


  • 4.  RE: Granting Default Role in InformixHQ

    Posted Fri March 24, 2023 01:08 PM

    Yes, default roles is not part of IHQ. I trust you found how to mange permissions on databases and tables while logged in as the IHQ administrator under the DBServer Administration : Privileges option.

    IHQ DB permissions
    IHQ table perms


    ------------------------------
    Carlton Doe
    ------------------------------

    Original Message


  • 5.  RE: Granting Default Role in InformixHQ

    Posted Tue March 28, 2023 10:49 AM

    Yes, I found that.   Its frankly useless for me.   We apply roles across hundreds of tables to grant read only or update perms.    You are either a read-only user with the proper default role, or an update user with that role.

    I can't (won't) manage it at the table level.   

    I'll have to upgrade our AGS license for now until HQ matures.   Managing who is in a role is a minimum requirement for us.    I'm also really disappointed in the space/chunk management interface, especially as it pertains to mirrors.



    ------------------------------
    Jared Heath
    ------------------------------

    Original Message