Granting Default Role in InformixHQ
Answered: green (solid confidence) — Doug Lawry and Carlton Doe confirm InformixHQ cannot grant default roles; the asker accepted this and decided to stay on AGS.
Advisory only.
Posted in 2023
Jared Heath could not find a way to grant default database roles in InformixHQ. Doug Lawry and Carlton Doe confirmed HQ lacks it; Doug said HQ complements AGS rather than replacing it. Jared found the table-level privilege page unusable for hundreds of tables, criticised space/chunk and mirror management, and planned to upgrade his AGS license.
Topics: Security, Permissions & Auditing
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 ------------------------------
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.
It definitely needs some maturity. Especially in the space/chunk presentation, which is really poor ------------------------------ Jared Heath ------------------------------
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. ------------------------------ Carlton Doe ------------------------------
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 ------------------------------