Informix

 View Only
Expand all | Collapse all

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

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

    Posted 21 hours ago

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


  • 2.  RE: How to restrict specific ODBC/JDBC users from accessing the source code of SPL routines and triggers

    Posted 12 hours ago

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

    Original Message