Informix

 View Only
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 21 hours ago

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