Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jean-Guy Charron — source: IBM Community (ConnectedCommunity.org) Informix forum
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
------------------------------
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.