How to restrict specific ODBC/JDBC users from accessing the source code of SPL routines and triggers

I need to grant access to Informix IDS 14.10 to some users but I don't want them to have access to the SPL and triggers sources codes. I try creating a new database with views that point to the production db. But I need to grant connect to the prod db to the users so they can access directly the prod db and access the SPL source. Someone have and ideas ? Best Regards, ------------------------------ Jean-Guy Charron ------------------------------

Hi Jean-Guy. What you really need is CREATE PROCEDURE/FUNCTION ... WITH ENCRYPTION ... like SQL Server: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-ver16#syntax Anything complex in a trigger could or should be in a procedure anyway. There are two RFEs for exactly this (I previously voted for both): https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-214 https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-502 Can we all vote to get it actively considered again? ------------------------------ Doug Lawry Oninit Consulting ------------------------------