Hi Chuan,
My first recommendation - migrate to 14.10 or 15.0 . The next, to think about your user and role concept - levels, rules, HDR secondary updateable?
And maybe if you need some special handling of update/insert, you can use a trigger function to implement your business/security policy depending on the user. If you decide to use rules, you can set them with sysdbsopen procedure for each user.
Best Regards, Henri
------------------------------
Henri Cujass
leolo IT, CTO
Germany
IBM Champion
henri.cujass@leolo.com------------------------------
Original Message:
Sent: Tue December 16, 2025 10:36 PM
From: chuan lu
Subject: How to alter a table become a read only one?
HI,
I have read those document about table privileges in version 11.50。With such requirement I can't use HDR/RSS read only feature, because some table still need to be modified. Customer want to change a part tables to read only.
Do anyone have additional suggestion? thanks for your time
------------------------------
chuan lu
Original Message:
Sent: Tue December 16, 2025 02:43 AM
From: Marcus Haarmann
Subject: How to alter a table become a read only one?
Hi,
from my perspective, this is what Infmrmix Security Policies are for.
Have not used that, but you can find documentation here:
Best,
Original Message:
Sent: 12/16/2025 2:28:00 AM
From: chuan lu
Subject: How to alter a table become a read only one?
Hi,
The develop DBA want to change some tables to read only , include the DBA himself can't update/insert/delete those record also. Do anyone have experience how to implement it in informix? The document told me "You cannot revoke privileges from yourself."
Any suggestion are welcome.
------------------------------
chuan lu
------------------------------