I want to give my users only the following rights:
GRANT EXECUTE ANY PROCEDURE TO <user> WITH ADMIN OPTION;
GRANT EXECUTE ANY PROGRAM TO <user> WITH ADMIN OPTION;
If they open the Schema Browser, and go to the procedure they can see the code but if they go to packages, they only see package specs and NOT package bodies.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center