Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

How to restrict SPL and tiggers source code from odbc/jdbc request ?

  • 1.  How to restrict SPL and tiggers source code from odbc/jdbc request ?

    Posted Tue February 25, 2025 06:26 PM

    I have to give readonly ODBC/JDBC access to some users (select only on some tables).
    I don't want them to have access to SPL and triggers sources.
    If I revoke execute permissions on each procedures they can still see the source of them.

    I tried to create another database with views pointing to the production db but since I need to give them connect permission to the prod_db they have access to the SPL and triggers sources on the prod db.
    I don't give any table perms on these tables on the prod db.

    Does someone have a solution ?

    Best Regards



    ------------------------------
    Jean-Guy Charron
    ------------------------------


Related Content